Forum Discussion
Separating names into 2 columns
Try the following before trying to split the names:
- Select the column with names.
- Press Ctrl+H to activate the Replace dialog.
- Make sure that Num Lock is on.
- Click in the 'Find what' box and press Alt+0160 using the numeric keypad. this enters a non-breaking space.
- Click in the 'Replace with' box and press the spacebar. This enters an ordinary space.
- Click 'Replace All'.
Do the methods you used previously, such as Data > Text to Columns, work now?
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.
