=LEFT(A1,FIND(" ",A1)-1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Excel_help" wrote
in message ...

I need a formula that will allow me to only keep the first word in cells
that may have two words. Is this possible?

Thank you,
Andrew


--
Excel_help
------------------------------------------------------------------------
Excel_help's Profile:
http://www.excelforum.com/member.php...o&userid=36439
View this thread: http://www.excelforum.com/showthread...hreadid=566748