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.
