谢总 发表于 2021-11-8 17:05:00

如何用公式将大写的数字转换成阿拉伯数字

原站名:西瓜1-二十-三 新站名:西瓜-20-3
要求:如何用公式将中文数字转换成阿拉伯数字

聂青林 发表于 2021-11-29 11:30:45

=CONCAT(RIGHT(IFNA(MATCH(MID(A1,ROW(INDIRECT(1&":"&LEN(A1))),1),RIGHT(TEXT(ROW($1:$10),"")),),MID(A1,ROW(INDIRECT(1&":"&LEN(A1))),1))))

一点娱乐园 发表于 2021-12-30 21:44:56

谢谢各位大神

丿淡喏灬 发表于 2022-1-5 15:10:09

大神有没有直接可以复制的函数

被表白的灭火器 发表于 2022-1-7 14:51:56

{=LEFT(SUBSTITUTE(A6,"期“,”“),FIND("-",SUBSTITUTE(A6,""期","")))&MATCH(LEFT(MID(SUBSTITUTE(A6,"期“,”“),FIND("-",SUBSTITUTE(A6,"期“,”“))+1,99),FIND("-",MID(SUBSTITUTE(A6,"期“,”“),FIND("-",SUBSTITUTE(A6,"期“,”“))+1,99))-1),TEXT(ROW($1:$995),"[>20]G/通用格式;d"),
0)&"-"&MATCH(MID(MID(SUBSTITUTE(A6,"期“,”“),FIND("-",SUBSTITUTE(A6,"期“,”“))+1,99),FIND("-",MID(SUBSTITUTE(A6,"期“,”“),FIND(("-",SUBSTITUTE(A6,"期“,”“))+1,99))+1,99),TEXT(ROW($1:$995),"[>20]G/通用格
式;d"),0)}大神们这函数对吗

张缘哥军训商贸 发表于 2022-1-7 20:54:30

=LEFT(SUBSTITUTE(A1,"期",""),FIND("-",SUBSTITUTE(A1,"期","")))&MATCH(LEFT(MID(SUBSTITUTE(A1,"期",""),FIND("-",SUBSTITUTE(A1,"期",""))+1,99),FIND("-",MID(SUBSTITUTE(A1,"期",""),FIND("-",SUBSTITUTE(A1,"期",""))+1,99))-1),TEXT(ROW($1:$995),"[>20]G/通用格式;d"),0)&"-"&MATCH(MID(MID(SUBSTITUTE(A1,"期",""),FIND("-",SUBSTITUTE(A1,"期",""))+1,99),FIND("-",MID(SUBSTITUTE(A1,"期",""),FIND("-",SUBSTITUTE(A1,"期",""))+1,99))+1,99),TEXT(ROW($1:$995),"[>20]G/通用格式;d"),0)三键结束（按Ctrl+Shift+Enter）

怎么微信登陆不了啦 发表于 2022-1-25 22:10:47

感谢感谢大神
页: [1]
查看完整版本: 如何用公式将大写的数字转换成阿拉伯数字