Extract First Name from Full Name in Excel

Did you ever need to extract the first name from the full name because you get list of full names instead of first name? Well, it happens to me countless times where all I needed was the First Name. It would be so hectic & timewasting process if you extract first names manually. So, why not thanks to Excel for LEFT and FIND formulas to make our work easier.

Previously In Excel Formulas: How to use Division Formula in Excel?

Extract First Name from Full Name in Excel

All you need to do that:

To find the location of the space that separates the First Name and the Last Name you have to use the FIND formula.

However, to get the location of the end of the First Name you need to deduct this numerical location by 1.

After that you have to use the LEFT formula to retrieve the First Name with this number.

 Here are the steps are given below to follow in your Excel:

STEP1: Working With LEFT Function

Firstly, you need to enter the LEFT function and select the Full Name in your Excel sheet e.g.

=LEFT(A2

Extract First Name from Full Name in Excel

Now continue the formula by entering the FIND formula to get the empty space location between the first and last name;

=LEFT(A2, FIND(""
Extract First Name from Full Name in Excel

after second step you need to select the Full Name again to enter the FIND formula’s 2nd argument:

=LEFT(A2, FIND("",A2)
Extract First Name from Full Name in Excel

To get the result with the text up to the last letter of the first name, you need to deduct 1 from the FIND formula.

Extract First Name from Full Name in Excel

STEP2: Apply To ALL

By dragging the formula all the way down, apply the same for the rest of the cells.

There you had extract all the First Names from your FULL NAME by using the FIND formula in Excel!

Extract First Name from Full Name in Excel