View Single Post
  #4   Report Post  
Sandy Mann
 
Posts: n/a
Default

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?