Forum Discussion
Separating names into 2 columns
I have been able to separate first/last names from one column to 2 in the past but can no longer, and I don't understand why. When I have a list of names, some of which might be 2 words, some might ...
I went back and tried your suggestion again with clearing the data using ALT0160 and it has helped. I am still playing with it, but I thank you for that suggestion!
You may
=SUBSTITUTE(E3, " ", CHAR(160) )drag it down and split result. Before entering the formula be sure cells are in General format.
- Thank you!