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 ...
Thank you for your reply. I don't have a Num lock key nor an Alt key. I tried the ease of access keyboard to activate Num lock but can't do the same with Alt and enter the numbers at the same time.
EDIT: I figured out substitutes for the keys, but it didnt make a difference in the outcome.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
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!
