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)


Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
4 comments on “Tom’s Tutorials For Excel: Extracting the Last Word in a Cell
  1. Drita says:

    Very very good job, excellent.
    Thank you for your help Tom.

  2. subrata basak says:

    very good….very useful as well….

  3. rodes says:

    this is very helpful

Leave a Reply

Your email address will not be published. Required fields are marked *

*