Extract last word

[Aland2929]

I need to extract the last word in a column that has either two or three words and the first or first and second word. Is this possible? I have attached a sample file.
Thanks in advance

[bebo021999]

try this:
In C2

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255))

In B2:

=SUBSTITUTE(A2,E2,"")

Copy both down

[Aland2929]

Fantastic. Thanks so much.