You would need to know the city and state to which the zip code belonged.
What you would need to do is have a table that lists ZIP code, City, State
and then run VLOOKUPs on that table from your list of ZIP codes. One place
to start your research would be he
http://en.wikipedia.org/wiki/List_of..._United_States
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?