Forum Discussion
Convert txt to excel
I have tried to convert a column of names (first name and last name only) into 2 columns using the "text to columns" wizard. At first, I was completely successful. Now, for some reason, I'm unable ...
Hi Terry Thomas
While doing Text to Column,
1. Select upto the end of data in a row.
2. In your case, you mentioned as first name & last name. So there must be a space (or) comma between first and last name. Then use "Delimited" option in "Text to Column".
3. Make sure that column separated as two, before clicking "Finish".