keep first word only
 

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

Thank you,
Andre

--
Excel_hel
-----------------------------------------------------------------------
Excel_help's Profile: http://www.excelforum.com/member.php...fo&userid=3643
View this thread: http://www.excelforum.com/showthread.php?threadid=56674

keep first word only
 

=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

keep first word only
 

Thanks, Bob

It doesn't seem to work, thoug

--
Excel_hel
-----------------------------------------------------------------------
Excel_help's Profile: http://www.excelforum.com/member.php...fo&userid=3643
View this thread: http://www.excelforum.com/showthread.php?threadid=56674

keep first word only
 

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

David F Cox


"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

keep first word only
 

Thanks, David.

How would I alter the formula so that the first letter is als
capitalized. Sorry that i did not mention this initially.

Andre

--
Excel_hel
-----------------------------------------------------------------------
Excel_help's Profile: http://www.excelforum.com/member.php...fo&userid=3643
View this thread: http://www.excelforum.com/showthread.php?threadid=56674

keep first word only
 

Try

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


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