单元格中文本一至九，快速替换为数字1-9

旗旗后期工作室

哈哈感谢您的提醒，完全忽略了地名可能会有数字这种情况（虽然可能不会遇到）

冷面少侠

比录制宏效率还高?

细雨带风

=LOOKUP(,-FIND(TEXT(ROW($1:10),"[dbnum1]d"),C2),SUBSTITUTE(C2,TEXT(ROW($1:10),"[dbnum1]d"),ROW($1:10)))

候学忠

我觉得还是来个附件吧。。。

迩做的真到位

=CONCAT(IFERROR(MATCH(MID(A1,ROW($1:$99),1),TEXT(ROW($1:$9),"[dbnum1]"),),MID(A1,ROW($1:$99),1)))

老涂

=LOOKUP(,0/(SUBSTITUTE(A1,{"一","二","三","四","五","六","七","八","九","十"},{"1","2","3","4","5","6","7","8","9","10"})<>B4),SUBSTITUTE(A1,{"一","二","三","四","五","六","七","八","九","十"},{"1","2","3","4","5","6","7","8","9","10"}))在你的基础上改一下

葛磊

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"一",1),"二",2),"三",3),"四",4),"五",5),"六",6),"七",7),"八",8),"九",9),"十",10)

刘秀亮

=REPLACE(A1,SUM(IFERROR(FIND({"一","二","三","四","五","六","七","八","九"},A1),0)),1,MATCH(1=1,ISNUMBER(FIND({"一","二","三","四","五","六","七","八","九"},A1)),))

镇东

杭州一办替换没问题，但是二、三、四……都提示#VALUE!，不过还是要谢谢您

春风自来

=LOOKUP(,0/(SUBSTITUTE(A1,{"一","二","三","四","五","六","七","八","九","十"},{"1","2","3","4","5","6","7","8","9","10"})<>B4),SUBSTITUTE(A1,{"一","二","三","四","五","六","七","八","九","十"},{"1","2","3","4","5","6","7","8","9","10"}))在你的基础上改一下