Frequently Asked Questions

was designed with your needs in mind. So, there is a good chance that you will find the answer to your question here. Plus, it is available to you 24 hours a day, 7 days a week.

Select a topic to start

Search by Topic

Search by Keyword

How do I separate my contacts' first and last names in Excel?

It is very easy to split first names and last names that appear in the same column in Excel into two columns.

Before you can separate the information into two columns, you'll need to make sure that the column to the right of the contact name is empty. If it is not empty, highlight the column to the right of the name field, right-click and select Insert. Then follow these steps:
  1. Click on the heading of the column containing your contacts' first and last names to highlight the column.
  2. Click Data tab and select option Text to Columns.
  3. Select the Delimited radio button.
  4. Click Next.
  5. Under Delimiters, clear all the check boxes and check only the Space check box.
  6. Click Finish.
Your contacts' first and last names will now be in two separate columns.

Was this FAQ helpful? print up down



More related questions