How to get the right-most word from TEXT

B

BC

Please let me know if there is a easy way to do this:

Cat Dog monkey => monkey
This is a test => test
I love you => you

Thanks.

BC
 
R

Ron Coderre

Try this:

For text, including spaces, in A1
B1: =RIGHT(A11,LEN(A11)-LOOKUP(LEN(A11),FIND("
",A11,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A11),1)))))

That formula pulls the text after the last space from A1.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top