Thank you Stefi, Pete and Dave. Things worked out well. I ran into one more
column problem. I need to separate three pieces of information into separate
columns, that is city, state, zip. Here is what my problem looks like.


OAK PARK, IL 60302
OAK PARK, IL 603020000
OAK PARK, IL 60302
OAK PARK, IL 60302
OAK PARK, IL 603024272
OAK PARK, IL 60302
OAK PARK, IL 603022609
OAK PARK, IL 603024272
OAK PARK, IL 60304
OAK PARK, IL 603020000
OAK PARK, IL 60302
OAK PARK, IL 60304
OAK PARK, IL
OAK PARK, IL 60304
OAK PARK, IL 60302
OAK PARK, IL 60302
OAK PARK, IL 603020000
OAK PARK, IL 60302
OAK PARK, IL
OAK PARK, IL 60304
OAK PARK, IL 60302
OAK PARK, IL 60304
OAK PARK, IL 60302
OAK PARK, IL 60302
OAK PARK, IL
OAK PARK, IL 60302
OAK PARK, IL 60304

--
Templar