Extract a word starting from Right

[Colleen45]

How would I extract the first word starting from the right, The word will be variable so I'm not sure if RIGHT function will work here. I was thinking maybe extracting all the characters starting from the right until it comes accross the first "space", but not sure which function/formula to use.

 

[VoG]

Here's one I made earlier

http://www.mrexcel.com/forum/showthread.php?t=464021

 

[Richard Schollar]

Formula wise:

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))

 

[Colleen45]

Peter (Vog), I battled on yours, Obviosly (me) doing something wrong

Richard , yours worked well
Thankyou both for your help

Regards