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:

    1. Select the A 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 Tab and Space are selected, then select Next

    6. Select Finish

This should separate first and last names into two columns.