Showing data either side of '/'

[Dave]

hi,

i have a cell which will always have data in it seperated
by '/', ie 60/60, or 120/120. The problem is that the 2
data values either side can be either 1, 2 or 3 digits in
length (ie 6, 60 or 120).

is there a function, similar i guess to LEFT/RIGHT, which
can show me the data on one side of the '/'

thanks in advance
dave

 

[Anon]

hi,

i have a cell which will always have data in it seperated
by '/', ie 60/60, or 120/120. The problem is that the 2
data values either side can be either 1, 2 or 3 digits in
length (ie 6, 60 or 120).

is there a function, similar i guess to LEFT/RIGHT, which
can show me the data on one side of the '/'

thanks in advance
dave

=LEFT(A1,FIND("/",A1)-1)
and
=RIGHT(A1,LEN(A1)-FIND("/",A1))

 

[Peo Sjoblom]

Why not left or right?

=LEFT(A1,FIND("/",A1)-1)

or

=LEFT(A1,FIND("/",A1)-1)+0 if you want
it numeric

to the right you can use

=SUBSTITUTE(A1,LEFT(A1,FIND("/",A1)),"")

or

=SUBSTITUTE(A1,LEFT(A1,FIND("/",A1)),"")+0

for numeric

you could use right or mid as well