连接文本函数:如在身份证中提取日期1992-07-22
=CONCATENATE(MID(N3,7,4),"-",MID(N3,11,2),"-",MID(N3,13,2))
在身份证中提取日期格式如:1992-7-2
=IF(MID(J191,13,1)="0",IF(MID(J191,11,1)="0",CONCATENATE(MID(J191,7,4),"-",MID(J191,12,1),"-",MID(J191,14,1)),CONCATENATE(MID(J191,7,4),"-",MID(J191,11,2),"-",MID(J191,14,1))),IF(MID(J191,11,1)="0",CONCATENATE(MID(J191,7,4),"-",MID(J191,12,1),"-",MID(J191,13,2)),CONCATENATE(MID(J191,7,4),"-",MID(J191,11,2),"-",MID(J191,13,2))))