PS: 身份证号啥的都是乱写的
## 示例:从身份证号中提取出生日期
## 步骤
1. 选中身份证那一列(表格最上方都有字母,单击该字母即可选取该列)
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwMzcwODUzMy0xMTgxMzk4MzUucG5n.png?w=700)
2. 在最上方的菜单栏上选择\'数据\'
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwMzgyMjQ0MS0xMzE0NzM3MTU0LnBuZw%3D%3D.png?w=700)
3. 在下方选择\'分列\'
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwMzgzMjk4MC0yMDY4MDA2MDE5LnBuZw%3D%3D.png?w=700)
4. 选择\'固定宽度(W)\',然后下一步
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwMzg0ODgzNi0xODMwMDE4Mzc0LnBuZw%3D%3D.png?w=700)
5. 在下方数据预览窗口的拉取两条分割线(单击左键),将出生日期与其他数据分开,然后下一步
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwMzkxMTIzNC0xMTA3ODM0NTEzLnBuZw%3D%3D.png?w=700)
6. 分别单击选取第一个和第三个区域(被选中的区域颜色会变黑),然后在上方列数据格式中选择\'不导入此列(跳过)\'
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwMzk0ODk5NS04MTMyMDY4NzAucG5n.png?w=700)
7. 选取中间所需数据,然后选择\'日期\'
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwNDAwNTUzMi0xNjExMDA4MTM0LnBuZw%3D%3D.png?w=700)
8. 单击窗口中间的目标区域的末端按钮
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwNDAyMDgzNi02MDE0NjMxMTMucG5n.png?w=700)
9. 在表格中选取新列(数据将会在此列生成),然后Enter建回车
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwNDA0NDU1MC0xODUwMTg2NTA0LnBuZw%3D%3D.png?w=700)
10. 单击\'完成\'
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwNDE1NDkwNi0xMTE1ODIyNTI0LnBuZw%3D%3D.png?w=700)
11. 数据自动生成了~~~
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwNDIxNDQwNy0yNzQ3NDEyMy5wbmc%3D.png?w=700)
## 备注
+ 身份证号目前是18位,而在excel表格中,常规的单元格格式,在数字超过15位之后,超过的位数会自动变为0,需要将单元格格式设置为文本
+ 强迫症,觉得x/x/x不太好看,选取该列,单击右键,选择\'设置单元格格式\',选择自定义,选择喜欢的类型,搞定
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwNDIyNjY0NS0xNDEyMDQyODI4LnBuZw%3D%3D.png?w=700)
最后附上长图:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMjA4OTY0OC8yMDIwMDcvMjA4OTY0OC0yMDIwMDcyMTEwNDQwNjc3OC02ODI2NDQwNDYucG5n.png?w=700)