C2=IFERROR(LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$99),"[DBNUM1]"),"一十","十")&"年",A2),ROW($1:$99)&"年"),"")&IFERROR(LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$99),"[DBNUM1]"),"一十","十")&"个月",A2),ROW($1:$99)&"个月"),"")&IFERROR(LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$99),"[DBNUM1]"),"一十","十")&"天",A2),ROW($1:$99)&"天"),"")
留言
張貼留言