Get First and Last Name Excel from Name

Get First and Last Name Excel

To get First and Last Names in excel, excel users can use the combination of LEFT, RIGHT, SEARCH, & FIND Functions. If you have a list of full names and want to split the full names into first and last names as shown below, you can easily do so by using combination of LEFT, RIGHT, SEARCH, and FIND.

Get First Names: With LEFT and FIND | With LEFT and SEARCH | Using Text to Columns

Get Last Names: with RIGHT, LEN, and FIND | with RIGHT, LEN, and SEARCH

Example 1: Extract the first Name with LEFT and FIND:

Question: I have a list of full names. how can I extract the first names only.

Answer: The formula is =LEFT(C6, FIND(” “, C6)-1), which returns the first names only.

Example 2: Extract first names with LEFT and SEARCH:

Question: How can I extract first names by using LEFT and SEARCH?

Answer: The formula is =LEFT(SEARCH(” “, C6)-1), which returns the first names.

Example 3: Get first Names without formula:

Question: How can I get the first names without using formula?

Answer: Follow the steps.

Step 1: Select the full names

Step 2: Click on Data tab–> Then click on Text to Columns

Step 3: Choose delimiter

Step 4: Select Space as delimiter

Step 5: Click Next

Step 6: Click FINISH.

Example 4: Get last name with RIGHT and FIND:

Question: How can I extract last name from full name?

Answer: The formula is =RIGHT(C6, LEN(C6)-SEARCH(” “, C6)), which returns the last names in D5-D10.

Question: How to extract last names with RIGHT and SEARCH?

Answer: The formula is exactly the same except the use of SEARCH. Replace FIND with SEARCH in the above formula, and you are done.

More related reading:

MS Office Post

SUBSTITUTE

REPLACE