=MID(A2,MIN(FIND({0,1,2,3,4,5,-查字典问答网
分类选择

来自胡建明的问题

  =MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890)),LEN(A2)*10-SUM(LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},))))*1

  =MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&1234567890)),LEN(A2)*10-SUM(LEN(SUBSTITUTE(A2,{0,1,2,3,4,5,6,7,8,9},))))*1

1回答
2020-12-0504:54
我要回答
提示:回答问题需要登录哦!
代贵华

  此公式是提取A2单元格中文本中的数字,如a2中是金额12589元,那么就提取12589这个数字

2020-12-05 04:56:06
大家都在问
最新问答