Wednesday, May 18, 2005

Splitting first and last names in Excel

I received an email from ExcelTip.com the other day that explained how to separate a column of first and last names into two columns, first and last separately. I knew how to do it conceptually but had never bothered.
Anyway today I was asked that very same question and I was able to explain!


Select the column with the fullnames in it making sure there is an empty column to the right.
Select Data | Text to Columns.
Select Delimited in step 1 and Click Next
Check the space checkbox in step 2 and click Finish.
Voila!