If you have a list of people in Excel with first and last names that you would like to create two columns to separate first and last names, please follow these steps:
(If you already have data to the Right of the column you are modifying create a new blank column to the Left)
1. Select the column at the top of the spreadsheet
2. Select the Data tab at the top of the screen
3. Select Text to Columns about halfway across the screen
4. Ensure the file type selected is Delimited, then select Next
5. Make sure that the correct type(s) of delimiter are selected, then select Next
6. Select Finish
Your first and last names into should not appear in two separate columns.