Got a problem with an Excel spreadsheet. I have a non-specific data column in an Excel 2007 spreadsheet. The data in one column is zip codes in the form of both zip (5 digit, 00000) and zip+4 (10 ...

You could enter everything but the city and state in excel, then import it all into access and run a query against a zip code/city/state database (which you'd have to buy, they can be had for ...