=right(driving me crazy)

[Mark McInerney]

Hi,

I have a column of 1000 entries - with 4 words in each cell (all of different lengths) - I need to extract the last word from each cell.

I have been playing around with the right function but cannot get it just right.

Any Help - Appreciated - Thanks - Mark.

 

[RoryA]

Assuming the words are separated by spaces:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",500)),500))