| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separate parts of a name into three cells
I have a name cell that has last, first middle. How can I separate the last
into one cell, the first in the next cell and the middle in the next. The last and first have a , and a space between them and there is a space between the first and the middle. Thanks in advance for your help! Liz |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separate parts of a name into three cells
Hi,
Select the column of data then Data|Text to columns - Delimited Next Check space and comma Finish "Liz C" wrote: I have a name cell that has last, first middle. How can I separate the last into one cell, the first in the next cell and the middle in the next. The last and first have a , and a space between them and there is a space between the first and the middle. Thanks in advance for your help! Liz |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separate parts of a name into three cells
That was too simple. Duh! I've even done it before but couldn't remember.
Thanks, Mike! "Mike H" wrote: Hi, Select the column of data then Data|Text to columns - Delimited Next Check space and comma Finish "Liz C" wrote: I have a name cell that has last, first middle. How can I separate the last into one cell, the first in the next cell and the middle in the next. The last and first have a , and a space between them and there is a space between the first and the middle. Thanks in advance for your help! Liz |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Separate parts of a name into three cells
your welcome
"Liz C" wrote: That was too simple. Duh! I've even done it before but couldn't remember. Thanks, Mike! "Mike H" wrote: Hi, Select the column of data then Data|Text to columns - Delimited Next Check space and comma Finish "Liz C" wrote: I have a name cell that has last, first middle. How can I separate the last into one cell, the first in the next cell and the middle in the next. The last and first have a , and a space between them and there is a space between the first and the middle. Thanks in advance for your help! Liz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for separating parts of cells | Excel Worksheet Functions | |||
| separate two dates from a text string into two separate cells | Excel Discussion (Misc queries) | |||
| COUNTIF in a range (and parts of cells) | Excel Worksheet Functions | |||
| Deleting Parts of Cells | Excel Discussion (Misc queries) | |||
| is there an easy way to move parts of cells around | Excel Discussion (Misc queries) | |||
Linear Mode
