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 ...

How to Open a Zip File in Excel 2007. A ZIP file usually contains several other files that have been compressed to a smaller size and bundled into a single package with a .zip filename extension.

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 ...