Advertisements

Extract last Name in Excel

Using MID, RIGHT, FIND, and SEARCH, users can extract last name in excel. Here are the best possible solutions to extract last names in excel.
In this section:


  1. Extract last name from first and last names separated by space
  2. Extract last name from first and last names separated by comma
  3. Extract last name from first, middle, and last name
  4. Extract last name from email address

1. Extract last name from first and last names separated by space:

Advertisements

To extract the last name from full name, the formula is =MID(C6, FIND(” “, C6), 100), which returns the last names from the full names.

Extract last name with space

2. Extract last name from first and last names separated by comma:

To extract the last name with comma, the formula is =LEFT(C6, FIND(“,”, C6)-1), which returns the last name, which is in the first position in the data.

Extract last name in excel with comma

3. Extract last name from first, middle, and last names:

To extract the last name from first, middle, and last name, the formula is =RIGHT(C6,LEN(C6)-FIND(““,SUBSTITUTE(C6,” “,”“,LEN(C6)-LEN(SUBSTITUTE(C6,” “,””))))), which returns the last names in column D.

Extract Last Name in excel

4. Extract last name from email address:

To extract last name from email address, the formula is =LEFT(RIGHT(C6,LEN(C6)-FIND(“.”,C6)),FIND(“@”,RIGHT(C6,LEN(C6)-FIND(“.”,C6)))-1), which returns the last name from email address.

Extract Last Name in excel

More related readings:

  1. Extract first Name in excel (3 practical examples)
  2. Extract Middle names (3 practical examples)
  3. Excel ARRAYTOTEXT Function
  4. Excel CLEAN Function with practical examples
  5. Excel CONCAT Function to join text
  6. Excel REPLACE Function to replace text
  7. Excel TRIM Function with Practical Examples
  8. Get Name from email address

2 Responses

  1. The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you could fix if you werent too busy looking for attention.

Leave a Reply

Your email address will not be published. Required fields are marked *

Advertisements