Truncate Name

Hi, how do I extract the first names from the various cells? I have thousands so it is impossible to do it manually. Thanks in advance!

For example
A1 = John Waters. Should be John.
A2 = Barry Johnson. Should be Barry
A3 = Fredderick Rogers. Should be Fredderick

Hi

I would use Data/Text to Columns, using a space as the delimiter. It's
fairly easy to do but backup your data before you start.

Andy.

"ernestgoh" <ernestgoh.25j00y_1143794700.6703@excelforum-nospam.com> wrote
in message news:ernestgoh.25j00y_1143794700.6703@excelforum-nospam.com...
>
> Hi, how do I extract the first names from the various cells? I have
> thousands so it is impossible to do it manually. Thanks in advance!
>
> For example
> A1 = John Waters. Should be John.
> A2 = Barry Johnson. Should be Barry
> A3 = Fredderick Rogers. Should be Fredderick
>
>
> --
> ernestgoh
> ------------------------------------------------------------------------
> ernestgoh's Profile:
> http://www.excelforum.com/member.php...o&userid=24870
> View this thread: http://www.excelforum.com/showthread...hreadid=528471
>

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


ernestgoh <ernestgoh.25j00y_1143794700.6703@excelforum-nospam.com> wrote in
message news:ernestgoh.25j00y_1143794700.6703@excelforum-nospam.com...
>
> Hi, how do I extract the first names from the various cells? I have
> thousands so it is impossible to do it manually. Thanks in advance!
>
> For example
> A1 = John Waters. Should be John.
> A2 = Barry Johnson. Should be Barry
> A3 = Fredderick Rogers. Should be Fredderick
>
>
> --
> ernestgoh
> ------------------------------------------------------------------------
> ernestgoh's Profile:
http://www.excelforum.com/member.php...o&userid=24870
> View this thread: http://www.excelforum.com/showthread...hreadid=528471
>

PGC you are a genius!! It works a treat. Thanks guys for your input. Thanks again!