Help

Extracting last names | last word from a multi-word string

11909 11
cancel
Showing results for 
Search instead for 
Did you mean: 

The question of how to extract the last name from a combined “first [middle][…] last [suffix]” name string – or the last word from a multi-word string – comes up from time to time. I offer a solution (with caveats) in a reply to a recent support post. My example is name-oriented but could easily be adapted to an arbitrary string. Hope this will save someone some time!

11 Replies 11

Welcome to the community, @Margaret_Pickering1! :grinning_face_with_big_eyes: For what it’s worth, the solution above is several years old. There are more efficient ways of doing this using regular expressions. Extracting the last word of a string can be done with this formula:

IF(Name, REGEX_EXTRACT(Name, "[^ ]*$"))

Thanks, that is helpful