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

M

Mary

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?
 
D

David Biddulph

Mary said:
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?
Click to expand...

The easiest way is from the Data menu/ Text to Columns:
Delimited: by commas
 
G

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
 
Top