We help IT Professionals succeed at work.

split city,state,zip into individual columns

zachvaldez
zachvaldez used Ask the Experts™
on
how will split  for example

Anycity,AnyState,99999 into separate columns.?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2008

Commented:
Data \ Text to Columns \ Delimited \ Comma

Thomas

Commented:
Did you tryed the Data-Text to Columns feature in Excel 2010?

Author

Commented:
correction
no comma between state and zipcode
"anycity,anystate 9999"
Top Expert 2008
Commented:
then
1. Data \ Text to Columns \ Delimited \ Comma
2. on your state ZIP column, Data \ Text to Columns \ Delimited \ Space

Thomas