First Word In Cell
Posted by Armando on January 07, 2002 1:20 PM
What is the formula so that I get the first word in a cell that has 10 words. Thanks
Posted by Aladin Akyurek on January 07, 2002 1:23 PM
If space separates words,
=LEFT(F2,FIND(" ",F2)-1)
otherwise replace " " the delimiter that you have like ",".
Aladin
Posted by Scott on January 07, 2002 1:27 PM
Try this:
=LEFT(A1,(SEARCH(" ",A1)-1))
