Excel Formula to return Last Word in a string

by Ramya 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
Razz
........

Tagged in:

1065
like
0
dislike
0
mail
flag

You must LOGIN to add comments