使用公式 如下,
=CONCATENATE((LEFT(RIGHT(A2,10),2)),-(LEFT(RIGHT(A2,8),2)),-(LEFT(RIGHT(A2,6),2)))
结果如下
身份证 |
|
34****19820820**** |
82-8-20 |
36****19860926**** |
86-9-26 |
34****19860504**** |
86-5-4 |
34****19860528**** |
86-5-28 |
34****19840805**** |
84-8-5 |
34****19820418**** |
82-4-18 |
35****19840415**** |
84-4-15 |
34****19850126**** |
85-1-26 |
34****19850126**** |
85-1-26 |
34****19810228**** |
81-2-28 |
37****19831015**** |
83-10-15 |
posted on 2010-01-15 19:20
期待明天 阅读(2198)
评论(0) 编辑 收藏 所属分类:
Non-tech