连接文本函数：如在身份证中提取日期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))))