|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 8th 05, 02:21 PM
|
|||
|
|||
How do I separate words in one cell into two cells?
I have a column that has both first and last names in it. I would like to
separate the two into two separate columns. The text to column feature doesn't work (at least how I know to use it) because the people's names are of such different lengths. Can anyone help me so I don't have to manually separate hundreds of names? Thanks! 
|
| Ads |
|
#2
June 8th 05, 02:29 PM
|
|||
|
|||
|
First, I'm assuming that there is a first name and a last name and no middle
name. If there is, you'll still have to do some data manipulation. This should get you part of the way. Data -> Text to Columns Select "Delimited" Select "Space" Select "Finish" "Vanessa" wrote: > I have a column that has both first and last names in it. I would like to > separate the two into two separate columns. The text to column feature > doesn't work (at least how I know to use it) because the people's names are > of such different lengths. Can anyone help me so I don't have to manually > separate hundreds of names? > Thanks!
|
|
#3
June 8th 05, 02:29 PM
|
|||
|
|||
|
If, for all cells, first and last names are written with a space between, you
can use the text to column tool, choose the option "delimited" and tick "space" option. Then you'll have all names separated in 2 columns. "Vanessa" wrote: > I have a column that has both first and last names in it. I would like to > separate the two into two separate columns. The text to column feature > doesn't work (at least how I know to use it) because the people's names are > of such different lengths. Can anyone help me so I don't have to manually > separate hundreds of names? > Thanks!
|
|
#4
June 8th 05, 02:32 PM
|
|||
|
|||
|
In the Text to columns feature, use Delimited instaed of Fixed Width, and use
a space as the delimiter. You'll have to eyeball the results to deal with names like Jill St. John "Vanessa" wrote: > I have a column that has both first and last names in it. I would like to > separate the two into two separate columns. The text to column feature > doesn't work (at least how I know to use it) because the people's names are > of such different lengths. Can anyone help me so I don't have to manually > separate hundreds of names? > Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Separate first and second name in one cell into separate cells. | Dwight in Georgia | Excel Discussion (Misc queries) | 3 | January 25th 06 09:09 PM |
| Copy cell format to cell on another worksht and update automatical | kevinm | Excel Worksheet Functions | 21 | May 19th 05 11:07 AM |
| Excel formula for seperating two words in the same cell. | Mim | New Users to Excel | 2 | March 8th 05 11:33 PM |
| How do I make a cell equal to another cells value and not it's fo. | TroutKing | Excel Worksheet Functions | 2 | January 17th 05 06:15 PM |
| Convert data type of cells to Text,Number,Date and Time | Kevin | Excel Worksheet Functions | 1 | December 31st 04 12:57 PM |
Linear Mode
