How to get the right-most word from TEXT
Some typos in that formula:
B1: =RIGHT(A11,LEN(A11)-LOOKUP(LEN(A11),FIND("
",A11,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A11),1) ))))
The refs to A11 should be to A1
Correct formula:
B1: =RIGHT(A1,LEN(A1)-LOOKUP(LEN(A1),FIND("
",A1,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A1),1))) ))
(Sorry for any confustion)
***********
Regards,
Ron
XL2002, WinXP
"Ron Coderre" wrote:
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
"BC" wrote:
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
|