J
John Corbin
I have text like
xyz abc/12
I user this formula to retrieve the number after the /
=RIGHT(H2,LEN(H2)-FIND("*",SUBSTITUTE(H2,"/","*",LEN(H2)-
LEN(SUBSTITUTE(H2,"/","")))))
This works.. provided there is a number after the / or even an / in
the string I am looking at.
Thus if I have
xyz abc
the above formula returns #VALUE! I expect this
I put an IF condition in and the formula becomes
=IF(RIGHT(H2,LEN(H2)-FIND("*",SUBSTITUTE(H2,"/","*",LEN(H2)-
LEN(SUBSTITUTE(H2,"/",""))))) < 999,(RIGHT(H2,LEN(H2)-
FIND("*",SUBSTITUTE(H2,"/","*",LEN(H2)-
LEN(SUBSTITUTE(H2,"/","")))))),"UNKNOWN")
it returns UNKNOWN always, regardles of wether or not a number is
really in the place I am hoping it is.
What is wrong ?
xyz abc/12
I user this formula to retrieve the number after the /
=RIGHT(H2,LEN(H2)-FIND("*",SUBSTITUTE(H2,"/","*",LEN(H2)-
LEN(SUBSTITUTE(H2,"/","")))))
This works.. provided there is a number after the / or even an / in
the string I am looking at.
Thus if I have
xyz abc
the above formula returns #VALUE! I expect this
I put an IF condition in and the formula becomes
=IF(RIGHT(H2,LEN(H2)-FIND("*",SUBSTITUTE(H2,"/","*",LEN(H2)-
LEN(SUBSTITUTE(H2,"/",""))))) < 999,(RIGHT(H2,LEN(H2)-
FIND("*",SUBSTITUTE(H2,"/","*",LEN(H2)-
LEN(SUBSTITUTE(H2,"/","")))))),"UNKNOWN")
it returns UNKNOWN always, regardles of wether or not a number is
really in the place I am hoping it is.
What is wrong ?