如何提取指定字符后面的数值

体育爱好者

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

吴金鑫

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

聽海的歌

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

雅仙

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

牛鹏

=--RIGHT(SUBSTITUTE(B5,"/",rept(" ",9)),9)