How to Separate First and Last Names in Excel into 2 Separate Columns

If a customer has a list of 100 people for a roster with first and last names. And they are trying to separate the first and last names into two columns. They can quickly and easily separate it by doing the following:

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.