Thread
:
lookup within a cell
View Single Post
#
4
Sandy Mann
Posts: n/a
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?
Reply With Quote