| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I split names from one column to two?
I have a column with names such as Ann & Bill Smith, I know that I can select
the column and use the Data/Text to columns with single first /last name but what if this is the way my names are in the cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I split names from one column to two?
Use Data/Text to columns with a delimiter of &
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jesse" wrote in message ... I have a column with names such as Ann & Bill Smith, I know that I can select the column and use the Data/Text to columns with single first /last name but what if this is the way my names are in the cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split column | Excel Discussion (Misc queries) | |||
| How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
| Split 2 names within a cell in excel | Excel Worksheet Functions | |||
| Formula to Split First and Last Names | Excel Worksheet Functions | |||
| How do I split column? | Excel Discussion (Misc queries) | |||
Linear Mode
