Following in one cell. Need separate cells DE SOTO, TX, 75115, US

[Guest]

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?

 

[Ron de Bruin]

Hi Mary

Try Data>Text to columns in the menubar

 

[David Biddulph]

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

 

[Gord Dibben]

Data>Text to Columns>Delimited by comma.

Make sure you have 4 empty columns to the right of selected column.


Gord Dibben MS Excel MVP