truncate text to first word

  • Thread starter Thread starter Harry C
  • Start date Start date
H

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?
 
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?
 
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)
 
Since the cells with only first names had no following spaces, I had to
concatenate with " ", and then it worked great! Thanks!

Harry
 
Hi Harry,

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

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

?
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
 
Back
Top