How to extract last three words in a cell in Excel

For example, you have the following the text in a cell “A1″:

I want to extract the last three word in this cell

To extract the last three words from A1, assuming all words have 20 characters or less, use the following formula:

=TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",60)),180))

The result:

in this cell

Not working for you?

Remember to replace A1 with the cell that contains the string of words you want to parse out.

This entry was posted in Extracting words. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*