lookup within a cell

  • Thread starter Parsing data in a cell
  • Start date
P

Parsing data in a cell

I have data in a cell that looks like this ".287/.289". I want to parse out
the data in the next two adjcent cells. The number .287 in the next column
and .289 in the column after that. Any ideas?
 
B

Bill Kuunders

=LEFT(A1,4) and =Right(A1,4)
these cells will be in text format
if you need to calculate insert columns with =C1*1 for instance to convert
to numbers

Greetings from New Zealand
Bill K
 
A

Alan

One way,
With the data in A1, in B1
=LEFT(A1,FIND("/",A1)-1)
in C1
=RIGHT(A1,LEN(A1)-FIND("/",A1))
Regards,
Alan
 
S

Sandy Mann

Try using Data > Text to Columns... and use a forward slash as the
deliminator in step 2 and in the 3rd step select the adjacent cell.


HTH

Sandy
 
A

Alan

I was assuming that not all the data would consist of three decimal places,
some would be more or less. Bill is right though, this will return text
which is not conducive to reliable calculation. To convert to numbers,
change to,
=LEFT(A1,FIND("/",A1)-1)*1
and
=RIGHT(A1,LEN(A1)-FIND("/",A1))*1
Regards,
Alan.
 
B

Bill Kuunders

Thanks Sandy
Learning every day.
Never worked with the text to columns.
Bill K
 
Top