=CONCATENATE(TEXT(MID(E2,7,4),"0"),"-",TEXT(MID(E2,11,2),"0"),"-",TEXT(MID(E2,13,2),"0"))
E2为身份证号的所在的表格
从左提取:left(单元格,长度) 从右提取 righ(单元格,长度)
=CONCATENATE(TEXT(MID(E2,7,4),"0"),"-",TEXT(MID(E2,11,2),"0"),"-",TEXT(MID(E2,13,2),"0"))
E2为身份证号的所在的表格
从左提取:left(单元格,长度) 从右提取 righ(单元格,长度)