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 ...
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!