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.
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.
Now continue the formula by entering the FIND formula to get the empty space location between the first and last name;
after second step you need to select the Full Name again to enter the FIND formula’s 2nd argument:
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.
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!