Extract Last Name in Excel (4 Practical Examples)

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:

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.

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.

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.

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.

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