Forum Discussion
Parsing a column
I am trying to parse a column of names using the Data, Text to Columns function. I follow the directions to the letter and all it does is copy the original column to the next column without separati...
There are non-breaking spaces between the parts of the names.
In Step 2 of the Convert Text to Columns wizard, select Other.
Click in the box next to it.
Hold down Alt and press 0160 on the numeric keypad, then release Alt.
(Alternatively, select and copy one of the spaces before starting Text to Columns, and paste the space into the box).
Click Finish.
