MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Split the Content into Two Columns

January 31, 2002 - by Juan Pablo Gonzalez

Kristie asks:

I am trying to convert one column that has both last name and first name (LAST NAME, FIRST NAME M.I.) in it to two columns, one with last name and one with first name. Is there a way to do this?

To do this, use Text to Columns. Select the column where you have the names, go to Data, Text to Columns, select Delimited in Step 1, in Step 2 make sure that the comma checkbox is activated. Finally, in step 3 select a Destination cell (It defaults to the current cell). Hit Finish and that's it.