Formula to separate numbers

[sobrien1234]

In column A I have number codes as follows:
1234/8
45673/18
4672/294

In column B I want formula which will isolate and provide me with the number on the right of the "/" so the answers in column B would be
8
18
294

I know I have use text to columns but need a formula that saves me doing that every time

thanks

Seamus

 

[AlanY]

try

=TRIM(RIGHT(SUBSTITUTE(A1,"",REPT(" ",500)),500))

 

[jtakw]

Hi,

Use B1 or C1 formula if you want results converted to Real numbers.
Use D1 or E1 formula if you want results as Text ( in case there are leading zeros that you want to retain ).

Book1
	A	B	C	D	E
1	1234/8	8	8	8	8
2	45673/18	18	18	18	18
3	4672/294	294	294	294	294
4	123/0456	456	456	0456	0456
Sheet629

Cell Formulas
Range	Formula
B1	=MID(A1,FIND("/",A1)+1,99)+0
C1	=RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99)+0
D1	=MID(A1,FIND("/",A1)+1,99)
E1	=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99))

 

[sobrien1234]

try

=TRIM(RIGHT(SUBSTITUTE(A1,"",REPT(" ",500)),500))

Thanks Alan - worked well - just had to add the backslash in and it was fine.

 

[sobrien1234]

Thanks that's great!!

 

[AlanY]

Thanks Alan - worked well - just had to add the backslash in and it was fine.

you're welcome
i though the / was it, don't know what happened to it