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.
"Alan" wrote in message
...
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?