Excel Formula to return First Word in a string

by Ramya 2010-02-04 18:51:06

Excel Formula to return First Word in a string:

To return first word in a string, use the following formula,
=LEFT(Cell Name,FIND(" ",Cell Name,1))


For example,
if a cell A1 contains the string "Enrique Iglesias" and to return only first part of the name,
=LEFT(A1,FIND(" ",A1,1))


Output:
Enrique

Razz
........

Tagged in:

801
like
0
dislike
0
mail
flag

You must LOGIN to add comments