最简单粗暴的方法:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(1234567890,IF(ISERR(FIND(1,A2)),,1),),IF(ISERR(FIND(2,A2)),,2),),IF(ISERR(FIND(3,A2)),,3),),IF(ISERR(FIND(4,A2)),,4),),IF(ISERR(FIND(5,A2)),,5),),IF(ISERR(FIND(6,A2)),,6),),IF(ISERR(FIND(7,A2)),,7),),IF(ISERR(FIND(8,A2)),,8),),IF(ISERR(FIND(9,A2)),,9),),IF(ISERR(FIND(0,A2)),,0),)
追问结果显示的3,我想要显示368,347
追答有测试了下,没毛病啊。你肯定哪儿搞错了
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9a504fc2d5628535e37b9f2199ef76c6a7ef6312?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)