Excel - Pull Last Name
Oct 12, 2021
277
To pull the last name out of a variable name list such as
Joe Smith
Alfred E. Newman
Josh Groban
Herman T. Munster
Use the following formula:
|
=RIGHT(C2,LEN(C2)-FIND("*",SUBSTITUTE(C2," ","*",LEN(C2)-LEN(SUBSTITUTE(C2," ","")))))
Where C2 is the location of the name that I want to pull apart.
|
