Display all characters after /

[Rubber Beaked Woodpecker]

Hi all

I thought that the following would be a relatively simple task but for some reason I am having trouble.

In N3 I have the fraction 1/8. I would like all the characters to the right of / to be displayed in O3 and have tried the following formula; =RIGHT(N3,SEARCH("/",N3))

However this returns /8 instead of the intended 8.

Where am I going wrong please.

TIA

RBW

 

[MountainFog]

You were almost there:

=RIGHT(N3,SEARCH("/",N3)+1)

Search returns the index of the character searched for. To return everything after that add 1

 

[MARK858]

Maybe the formula in O3

Book2
	N	O	P
3	1/8	8	1/8
b

Cell Formulas
Range	Formula
O3	O3	=RIGHT(N3,LEN(N3)-SEARCH("/",N3))
P3	P3	=RIGHT(N3,SEARCH("/",N3)+1)

 

[MountainFog]

You were almost there:

=RIGHT(N3,SEARCH("/",N3)+1)

Search returns the index of the character searched for. To return everything after that add 1

Thanks, Mark for the catch. It would be -1