二位數 數字改中文 (10643)


C2 {="第"&SUBSTITUTE(NUMBERSTRING(MAX(IFERROR(MIDB(B2,ROW($1:$9),2)*1,)),1),"一十","十")&"期"


D2="第"&SUBSTITUTE(NUMBERSTRING(-LOOKUP(9,-MIDB(B2,SEARCHB("?",B2),ROW($1:$9)*2)),1),"一十","十")&"期"


留言