A
Akhilesh Dalia
I have few hundred data in column A. Each cell contain 2 to 3 words. I want
last word from cell in another cell. I have tried right(), left() functions
but I'm not getting my desired output, because the length of last word is not
uniform. Following example will clarify more.
A B
XXX YYY YYY
XXXX YYYY YYYY
XX YY YY
XXX YYY YYY
XXXX YYYY YYYY
XX YY YY
Column A is my existing data and column B is desired one. Please help.
Regards
Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com
last word from cell in another cell. I have tried right(), left() functions
but I'm not getting my desired output, because the length of last word is not
uniform. Following example will clarify more.
A B
XXX YYY YYY
XXXX YYYY YYYY
XX YY YY
XXX YYY YYY
XXXX YYYY YYYY
XX YY YY
Column A is my existing data and column B is desired one. Please help.
Regards
Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com