Benchmark Email Help Center

or chat with:

smart support, our Benchmark Email expert powered by AI

chat now

Knowledge Base Home aero-right General Questions 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?

General Questions Updated on May 4, 2021

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.