提取出生日期- =TEXT(MID(A2,7,IF(LEN(A2)=18,8,6)),"0-00-00")+DATE(1900,1,0)
复制代码- =--TEXT(MID(A2,7,IF(LEN(A2)=18,8,6)),"#-00-00")
复制代码- =--TEXT((LEN(A2)=15)*19&MID(A2,7,6+(LEN(A2)=18)*2),"#-00-00")
复制代码 提取性别- =TEXT(MOD(RIGHT(LEFT(A2,17)),2),"男;;女")
复制代码- =IF(ISODD(RIGHT(LEFT(A2,17))),"男","女")
复制代码- =IF(LEN(MID(A2,IF(LEN(A2)=18,17,15),1)/2)=1,"女","男")
复制代码- =IF(ISEVEN(MID(A2,15,3)),"女","男")
复制代码- =IF(ISODD(MID(A2,IF(LEN(A2)=18,17,15),1)),"男","女")
复制代码- =IF(MOD(MID(A2,15,3),2)=1,"男","女")
复制代码 |