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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Leading zero from Zip Code not print on Label Merge 6
Excel data into Word 1
Zip Code formatting problem 3
Give error message 0
How do I get the "0" to print in the zip code when mail merging f. 4
Auto fill not working 2
Sort by how many addresses per zip code 4

Back
Top