One way,
With the data in A1, in B1
=LEFT(A1,FIND("/",A1)-1)
in C1
=RIGHT(A1,LEN(A1)-FIND("/",A1))
Regards,
Alan
"Parsing data in a cell" <Parsing data in a
wrote in message ...
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?