| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I truncate a text field in Excel? | Excel Worksheet Functions | |||
| How do you truncate 2.22 to just 0.22? | Excel Worksheet Functions | |||
| How do I truncate or hide portions of text in a pivot table? | Excel Worksheet Functions | |||
| how do i truncate text-- create cell with only 125 charecters | Excel Worksheet Functions | |||
| How do you truncate a text string? | Excel Worksheet Functions | |||
Hybrid Mode
