You're welcome Bill.

Learning every day.
Aren't we all


"Bill Kuunders" wrote in message
...
Thanks Sandy
Learning every day.
Never worked with the text to columns.
Bill K

"Sandy Mann" wrote in message
...
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


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