zachvaldez
asked on
split city,state,zip into individual columns
how will split for example
Anycity,AnyState,99999 into separate columns.?
Anycity,AnyState,99999 into separate columns.?
Did you tryed the Data-Text to Columns feature in Excel 2010?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
correction
no comma between state and zipcode
"anycity,anystate 9999"
no comma between state and zipcode
"anycity,anystate 9999"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thomas