How to Separate First and Last Name in Excel

This updated guide explains how to Separate First and Last Name in Excel through clear steps, practical examples, and important checks that help prevent common errors.

Perhaps this is the most common problem of office people. So let's not spend too much time with it.

Suppose we have to separate the first and last names from a list of the following 5 people:

Separate First and Last Name in Excel example screenshot 1

1. Speed Name

Copy column A to column C.
Specify the names that need separating first and last names in column C
Press Ctrl + F to open the search and replace dialog box
In the Find what dialog box in the Replace window, type: * _ (asterisk and space)
Select Replace All and wait for the miracle

Separate First and Last Name in Excel � 1. Speed Name screenshot 2

As a result, you have separated the name from the full name list.

Separate First and Last Name in Excel � 1. Speed Name screenshot 3

2. Separate the Rest of the Name.

So what about the rest of the name? Simple, please:

Point the mouse over cell B1
Enter the following formula: = LEFT (A1, LEN (A1) -LEN (C1))
Copy the remaining cells

So you have a complete list of first and last names:

Separate First and Last Name in Excel � 2. Separate the Rest of the Name. screenshot 4

social shareand social share

FAQ

What is the easiest way to Separate First and Last Name in Excel?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.