Even better: http://www.census.gov/tiger/tms/gazetteer/zips.txt

This is a comma delimeted file; in order to use its data you need to import
it into Excel, and use the text-to-columns tool in the Data menu to separate
the data into individual columns.

If you have questions about the VLOOKUP I mentioned in my other response,
post back.

Dave
--
Brevity is the soul of wit.


"Richardw" wrote:

If I have a long list of zip codes, is there any way to automatically convert
them to the appropriate city and state in a new column instead of looking up
every single one?