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

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

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

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?