how do I separate 1 excel column to read city, state, zip columns
 

I have an excel database with one field that contains city, state, zip. How
do I get the mail manager program to identify this column? It keeps asking
me to map a state or zip???