本帖最后由 YZC51 于 2019-12-7 21:08 编辑
完善下
=IF(ISERR(FIND("年",A2)),"",MATCH(LEFT(A2,FIND("年",A2)-1),TEXT(ROW($1:$100),"[<32][dbnum1]d;[dbnum1]"),)&"年")&IF(ISERR(FIND("个月",A2)),"",MATCH(SUBSTITUTE(MID(A2,IF(ISERR(FIND("年",A2)),1,FIND("年",A2)+1),99),"个月",""),TEXT(ROW($1:$100),"[<32][dbnum1]d;[dbnum1]"),)&"个月")
再减少几个字符
=IFERROR(MATCH(LEFT(A2,FIND("年",A2)-1),TEXT(ROW($1:$100),"[<32][dbnum1]d;[dbnum1]"),)&"年","")&IFERROR(MATCH(SUBSTITUTE(MID(A2,IF(ISERR(FIND("年",A2)),1,FIND("年",A2)+1),99),"个月",""),TEXT(ROW($1:$100),"[<32][dbnum1]d;[dbnum1]"),)&"个月","")
|