Split Full Names in Excel Spreadsheet
When you receive an Excel file with full names, you might want to split the full names into separate columns. Using the Excel program you can quickly separate the names.
Note: There are slight variations between Office 2003 and 2007. The basic functions remain the same.
The fastest way to is highlight Column A
This is a small sample of a full names spreadsheet.
Insert two columns to the right of Column A
The following displays your spreadsheet
Select the type of delimiter / Select Space / Finish
A pop-up displays / OK
The names are now split into three columns.
The last step is to rename the columns
The data is now converted.
The whole procedure takes less than 3-5 minutes for a large database.
July 05, 2012