Excel Formula to return First Word in a string
by Ramya[ Edit ] 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
........
