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

谢总

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

聂青林

=CONCAT(RIGHT(IFNA(MATCH(MID(A1,ROW(INDIRECT(1&":"&LEN(A1))),1),RIGHT(TEXT(ROW($1:$10),"[dbnum1]")),),MID(A1,ROW(INDIRECT(1&":"&LEN(A1))),1))))
工作簿1.zip (7.96 KB, 下载次数: 11)

2021-11-8 17:05 上传

点击文件名下载附件
工作簿1.zip

一点娱乐园

谢谢各位大神

丿淡喏灬

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

被表白的灭火器

{=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][dbnum1]G/通用格式;[dbnum1]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][dbnum1]G/通用格
式;[dbnum1]d"),0)}大神们这函数对吗

张缘哥军训商贸

=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][dbnum1]G/通用格式;[dbnum1]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][dbnum1]G/通用格式;[dbnum1]d"),0)三键结束（按Ctrl+Shift+Enter）

怎么微信登陆不了啦

感谢感谢大神