May 06 2019 09:51 AM
I had a list of contact information created from Pakistan. The file I received does not allow me use the data to column tool to quickly separate the first and last names. When I use the tool, it would only separate the second and third name if there were any. Office 365 tech support was not able to assist me. they sent me here.
May 06 2019 10:14 AM
You have both spaces and non-breaking spaces CHAR(160) as separator for the names. On second step of the wizard select space and Other. Into Other box pressing Alt type 0160 on Numepad (or copy the character from your text and paste).