Tom’s Tutorials For Excel: Extracting the Last Word in a Cell

Tom’s Tutorials For Excel: Extracting the Last Word in a Cell

When you want to extract the last word in a cell, be it a last name or whatever the word or character is that follows the last space in a string, this formula can do that, as seen in the picture.

I purposely broke the formula into two lines so it will display on this web page for all browsers, but you would enter it as one continuous statement, just as any formula.

=MID(A2,1+FIND("~",SUBSTITUTE(A2," ","~",
LEN(A2)-LEN(SUBSTITUTE(A2," ","")))),255)