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))
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.