Forum Discussion

Terry Thomas's avatar
Terry Thomas
Copper Contributor
May 19, 2018

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 to repeat the process with another file.  I've selected the column to be converted, I've followed the instructions in the wizard, but for some reason, (a) only the name at the top of the list is converted; (b) the wizard inserts 30 rows immediately following that single name; and (c) when I click on "finish," it tells me that there is data in the cells and asks if I want to replace it. None of these things happened the first several times I performed this action. I would appreciate any help/suggestions that I can get.  Clearly, I'm doing something wrong, but I have no clue what it might be.

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Steel Contributor

    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".

     

Resources