truncate text to first word
 

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?

truncate text to first word
 

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!
================================================== ===

"Harry C" wrote in message
...
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?

truncate text to first word
 

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)

--
Cheers,
Shane Devenshire


"Harry C" wrote:

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?

truncate text to first word
 

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

Harry
"ShaneDevenshire" wrote:

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)

--
Cheers,
Shane Devenshire


"Harry C" wrote:

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?

truncate text to first word
 

Hi Harry,

If the post is helpful you can click the Yes buttons to the right of the
question that marks the question appropriately.
--
Thanks,
Shane Devenshire


"Harry C" wrote:

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

Harry
"ShaneDevenshire" wrote:

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)

--
Cheers,
Shane Devenshire


"Harry C" wrote:

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?

truncate text to first word
 

In article , ?B?U2hhbmVEZXZlbnNoaXJl?= wrote:
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