Need a hand? We've got you covered.

Knowledge Base Home aero-right Contact Lists Create aero-right How do I separate my contacts’ first and last names in Excel?

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

Contact Lists Create Updated on July 23, 2011
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.
Did this answer your questions?
6 0

Can't find what you're looking for?

Submit a Ticket

view ticket history