Forum Discussion
Data to Column Issues
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 woul...
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).