| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Following in one cell. Need separate cells DE SOTO, TX, 75115, US
The following information (DE SOTO, TX, 75115, US) is in one cell in Excel.
I need to separate the city, state, zip, county into their own cells. Is there a formula to do this? -- Thanks, Mary |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Following in one cell. Need separate cells DE SOTO, TX, 75115, US
"Mary" wrote in message
... The following information (DE SOTO, TX, 75115, US) is in one cell in Excel. I need to separate the city, state, zip, county into their own cells. Is there a formula to do this? The easiest way is from the Data menu/ Text to Columns: Delimited: by commas -- David Biddulph |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Following in one cell. Need separate cells DE SOTO, TX, 75115, US
Hi Mary
Try DataText to columns in the menubar -- Regards Ron de Bruin http://www.rondebruin.nl "Mary" wrote in message ... The following information (DE SOTO, TX, 75115, US) is in one cell in Excel. I need to separate the city, state, zip, county into their own cells. Is there a formula to do this? -- Thanks, Mary |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Following in one cell. Need separate cells DE SOTO, TX, 75115, US
DataText to ColumnsDelimited by comma.
Make sure you have 4 empty columns to the right of selected column. Gord Dibben MS Excel MVP On Tue, 10 Oct 2006 10:29:01 -0700, Mary wrote: The following information (DE SOTO, TX, 75115, US) is in one cell in Excel. I need to separate the city, state, zip, county into their own cells. Is there a formula to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| Split data from one cell to two separate cells | Excel Worksheet Functions | |||
Hybrid Mode
