汉字转换为阿拉伯数字 (9749)

B1{=-LOOKUP(,-MATCH({"?",""}&A1,TEXT(ROW($1:$9999),"[DBnum1]"),))

另解{=MATCH(IF(LEFT(A1)="十","一"&A1,A1),NUMBERSTRING(ROW($1:$5000),1),)

另解{=MATCH(A1,SUBSTITUTE(TEXT(ROW($1:$10000),"[dbnum1]"),"一十","十"),)

有零 OK=LOOKUP(,0/(SUBSTITUTE(TEXT(ROW($1:$10000),"[dbnum1]"),"一十","十")=SUBSTITUTE(A1,"零","○")),ROW($1:$10000))