体育爱好者 发表于 2022-3-4 21:36:58

=SUBSTITUTE(RIGHT(B5,3),"/",)/1%%

吴金鑫 发表于 2022-3-11 17:27:51

2、3楼都有问小问题，比如这组9/10/14，结果会出错

聽海的歌 发表于 2022-3-18 07:25:39

=IMAGINARY(SUBSTITUTE(RIGHT(B5,4),"/","+")&"i")/1%%

雅仙 发表于 2022-3-23 22:16:11

谢谢指正，忽略了日期格式问题。
=-LOOKUP(,-RIGHT(SUBSTITUTE(C2,"/","@"),ROW($1:$10)))/1%%
画蛇添足了
3楼的没问题
=RIGHT(SUBSTITUTE(C2,"/","00000"),5)*10000

牛鹏 发表于 2022-3-27 02:52:02

=--RIGHT(SUBSTITUTE(B5,"/",rept(" ",9)),9)
页: 1 2 3 [4]
查看完整版本: 如何提取指定字符后面的数值