| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I extract part of a text string
I need to extract the first name from one cell and put it into another column.
Example: John Smith John Andrew Johnson Andrew Michael White Michael I'm sure its pretty easy, but I can't seem to figure it out. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract part of a text string
Use the text to columns tool--Data--Text to columns and select SPACE as your
delimeter. Note: any data to the right of the column the names are in will be deleted when you split the data into columns, so make sure you insert plenty of columns befiore doing this. Dave -- Brevity is the soul of wit. "Brennan" wrote: I need to extract the first name from one cell and put it into another column. Example: John Smith John Andrew Johnson Andrew Michael White Michael I'm sure its pretty easy, but I can't seem to figure it out. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract part of a text string
Try this:
=LEFT(A1,FIND(" ",A1)-1) Biff "Brennan" wrote in message ... I need to extract the first name from one cell and put it into another column. Example: John Smith John Andrew Johnson Andrew Michael White Michael I'm sure its pretty easy, but I can't seem to figure it out. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Formula to return part of a text string | Excel Discussion (Misc queries) | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| Extract text string using MID | Excel Worksheet Functions | |||
| Formula to extract digits from a text string? | Excel Worksheet Functions | |||
Linear Mode
