Separating Adress, City, State, Zip from single cell

[ADArnold]

Hi All;

I would like to separate the street address, city, state, zip in on
column cell (A2) to columns B-E.
For example: 1717 SE Any St., Cape Coral, FL 33990 contained in Cell A
to B2 C2 D2 E2. I would assume the separator would be commas, but yo
know better than I. Thank you pros for all of your previous help!

PS: It's a little windy here in Florida today...so please respon
before we lose power! Thanks

 

[Frank Kabel]

Hi
try using 'Data - Text to columns'

 

[Gord Dibben]

If consistent per your example, it would take two trips through the Data>Text
to Columns dialog.

First trip through use comma de-limited to break into B.

Next trip through use space de-limited to break up D into State ZIP

Gord Dibben Excel MVP

 

[ADArnold]

Worked great and so Simple!
Thanks Frank and Gord