How do I extract the last word in a text string?

[WildAngus]

Hi,

I have a string of information in a field and I want to extract the last word into another cell.
The values in the field are separated by spaces, so to extract the first bit of info I am using FIND to locate the first space then using LEFT with the result of the FIND-1. So this is simple.

I'm not finding it so simple to do this the other way round to pull out the right hand side of the text to do the equivalent for the last word.

I'm sure there's an easy way to do this, but as yet I haven't found it.

Any ideas anyone?

Thanks in advance.

 

[Richard Schollar]

Hi

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

 

[WildAngus]

Fabulous.

Thank you so much.