There were countless times when I had a list of full names, and all I needed was the First Name. It would be time-consuming to manually get the first names one by one. Thank goodness there are formulas to make my life easier!

In Excel, it’s very easy to do that with the LEFT and FIND formula!

Here is the gameplan:

  • Use the FIND formula to find the location of the space that separates the First Name and the Last Name
  • However we need to deduct this numerical location by 1, so that we have the location of the end of the First Name
  • With this number, we will use the LEFT formula to retrieve the First Name!

 

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the LEFT function and select the Full Name:

=LEFT(C7

 

STEP 2: We need to enter the FIND formula to get the empty space location between the first and last name:

=LEFT(C7, FIND(” “

 

STEP 3: Select the Full Name again for the FIND formula’s 2nd argument:

=LEFT(C7, FIND(” “, C7)

 

STEP 4: Deduct 1 from the FIND formula so that our result will return us the text up to the last letter of the first name:

=LEFT(C7, FIND(” “, C7) -1)

 

STEP 5: Do the same for the rest of the cells by dragging the formula all the way down using the left mouse button.

Now you are able to extract all the First Names from your FULL NAME using the FIND formula in Excel!

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

CountIfs Formula in Excel What does it do? Counts the number of cells that matches your specified conditions Formula breakdown: =COUNTIFS(range1, criteria1, , , ...) What it means: =COUNTIFS(range of cells to check1, condition to check against1, , , ...) Do you have a scenario where ...
Cleaning Data with Excel’s REPLACE Formula What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...
Replicating Excel’s FIND Function with M in ... Power Query lets you perform a series of steps to transform your Excel data.  There are times when we want to do things that are not built in the user interface.  This is possible with Power Query's formula language, which is called M. Unfortunately not all of Excel's formulas...
Count Text Occurrences with Excel’s SUBSTITU... What does it do? It replaces specific text in a text string i.e. Substitutes new text for old text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, ) What it means: =SUBSTITUTE(This cell, From this TEXT character, To this TEXT character, )...