Link to home
Start Free TrialLog in
Avatar of zachvaldez
zachvaldezFlag for United States of America

asked on

split city,state,zip into individual columns

how will split  for example

Anycity,AnyState,99999 into separate columns.?
Avatar of nutsch
nutsch
Flag of United States of America image

Data \ Text to Columns \ Delimited \ Comma

Thomas
Did you tryed the Data-Text to Columns feature in Excel 2010?
SOLUTION
Avatar of loopfinity
loopfinity

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of zachvaldez

ASKER

correction
no comma between state and zipcode
"anycity,anystate 9999"
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial