Showing data either side of '/'

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
Dave said:
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
Click to expand...

=LEFT(A1,FIND("/",A1)-1)
and
=RIGHT(A1,LEN(A1)-FIND("/",A1))
 
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
 
Back
Top