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)
Very very good job, excellent.
Thank you for your help Tom.
very good….very useful as well….
this is very helpful
Thank you!