Excel Formula to return Last Word in a string
by Ramya[ Edit ] 2010-02-04 18:58:54
Excel Formula to return Last Word in a string:
To return last word in a string, use the following formula,
=RIGHT(cell name,LEN(cell name)-FIND("*",SUBSTITUTE(cell name," ","*",LEN(cell name)- LEN(SUBSTITUTE(cell name," ","")))))
For example,
if a cell A2 contains the string "Enrique Iglesias" and to return only last part of the name use,
=RIGHT(A2,LEN(A2)-FIND("*",SUBSTITUTE(A2," ","*",LEN(A2)- LEN(SUBSTITUTE(A2," ","")))))
Output:
Iglesias
........
