=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
"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?