Sep 28 2020 12:55 PM
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 separating the space designator. Any ideas?
Sep 28 2020 01:04 PM
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.
Sep 28 2020 01:13 PM