keep first word only

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

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

--
HTH

Bob Phillips

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

"Excel_help" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Thanks, Bob

It doesn't seem to work, though

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

David F Cox


"Excel_help" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

Thanks, David.

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

Andrew

Try

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