How can I get the zip codes to addresses

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?
 
M

macropod

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

CyberTaz

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
 

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

Address Format changed after Migration 0
VLookup Function HELP 7
Mail Merge Directory Conditional Page Break 0
Filter ZIP codes into ranges 6
VLOOKUP formula? 12
Zip Codes 1
Merging from an Excel file with graphics 1
Working outlook via vba code with xlsx - error 0

Top