How can I get the zip codes to addresses

  • Thread starter Thread starter Ricardo Antonio
  • Start date Start date
R

Ricardo Antonio

I have a mess of addresses, but no zip codes. I use ms excel and a whole
column of zip codes to fill. Any advice, si vous ple?
 
Hi Ricardo,

Since this is an Excel question, you should post your query in an Excel newsgroup (eg microsoft.public.excel.worksheet.functions).

Assuming your data table has a column of suburb/locality names and a column of State names/codes, matching these to a table of zip
codes and State names/codes can by done via a lookup function.
 
Contact the Post Office & obtain a Zip Code Directory. You may be able to
Google one on line but I'm not sure how accurate it might be.

Good Luck |:>)
Bob Jones
[MVP] Office:Mac
 
Back
Top