truncate text to first word

[Harry C]

I have a column with first names, some of which are concatenated with middle
initials or middle names. Is there a way to truncate to just the first names?

 

[RagDyeR]

As long as there's a space between the first name and the rest:

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

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a column with first names, some of which are concatenated with middle
initials or middle names. Is there a way to truncate to just the first
names?

 

[ShaneDevenshire]

Hi Harry,

If they are not formulas you can use the Data, Text to Columns command and
choose Delimited, click next choose Space, click Next, and in the Preview
pane select each one of the "extra" columns and choose do not import skip.

If they are formulas then

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

 

[Harry C]

Since the cells with only first names had no following spaces, I had to
concatenate with " ", and then it worked great! Thanks!

Harry

 

[ShaneDevenshire]

Hi Harry,

If the post is helpful you can click the Yes buttons to the right of the
question that marks the question appropriately.

 

[Bruce Sinclair]

Hi Harry,

If the post is helpful you can click the Yes buttons to the right of the
question that marks the question appropriately.

?
There are no buttons in news groups. Is this group mirrored in whole or in
part by some kind of web forum ? Might explain the large number of strange
"froms" (starting with ?Utf-8?B? ...).

Thanks