Formula to extract the last word from a cell

[Dave K]

Anyone know of a formula that will extract the last word from a cell.

For example if cell contains the text: Best available title

How could I produce the result: "title"

(And preferably be able to fill the formula down the column to get the
last word from other cells in the column as well.)

Thanks for any suggestions.

 

[Bob Phillips]

=MID(A10,FIND(CHAR(1),SUBSTITUTE(A10," ",CHAR(1),B10))+1,99)

 

[Gary''s Student]

=RIGHT(A1,LEN(A1)-LOOKUP(LEN(A1),FIND("
",A1,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A1),1)))))

 

[Dave K]

=RIGHT(A1,LEN(A1)-LOOKUP(LEN(A1),FIND("
",A1,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A1),1)))))

Thanks a million!