旗旗后期工作室 发表于 2021-12-25 07:02:42

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

冷面少侠 发表于 2021-12-27 13:12:35

比录制宏效率还高?

细雨带风 发表于 2021-12-29 06:21:20

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

候学忠 发表于 2021-12-30 17:56:17

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

迩做的真到位 发表于 2022-1-7 23:19:41


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

老涂 发表于 2022-1-10 12:09:51

=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"}))在你的基础上改一下

葛磊 发表于 2022-1-12 23:39:54

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

刘秀亮 发表于 2022-1-13 16:23:09

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

镇东 发表于 2022-1-31 19:20:24

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

春风自来 发表于 2022-2-5 03:02:22

=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"}))在你的基础上改一下
页: 1 [2] 3 4
查看完整版本: 单元格中文本一至九，快速替换为数字1-9