C03:hrpotter- =RIGHT(19&MID(A4,7,(LEN(A4)=18)*2+6),8)
复制代码- =IF(MOD(RIGHT(LEFT(A4,17)),2),"男","女")
复制代码- =TEXT(B12,"公元yyyy年mm月dd日")
复制代码- =TEXT(B12,"yyyy年mm月dd日 aaaa")
复制代码- =MID(A8,FIND("@",SUBSTITUTE(A8,"-","@",3))+1,FIND("$",SUBSTITUTE(A8,"-","$",4))-1-FIND("@",SUBSTITUTE(A8,"-","@",3)))
复制代码- =MAX(--TEXT(MID(A10,ROW($1:$99),COLUMN(A:O)),"#;;0;\0"))
复制代码- =IF(TEXT(LOOKUP(MOD(SUM(MID(LEFT(A8,17),ROW($1:$17),1)*$D$7:$D$23),11),$F$7:$G$17),"0;;0;x")=RIGHT(A8),"真","假")
复制代码
C03-hrpotter-第五讲-文本函数.rar
(11.74 KB, 下载次数: 11)
|