Microsoft Excel 2007 - Convert One Column into Two

Sometimes you may have a list of names in a column, and you need to separate the first names from the last names. This is easy to do in Excel.

1. Highlight the column that you want to split into two columns.
2. Click on the Data tab
3. Select the Text to Columns button
4. Click Delimited, then Next
5. Click Space, then Next
6. Click Finish