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

Need VLOOKUP to Work Two Ways 0
Mail Merge 1
How do you get New England Zip codes to export all five digits? 6
VLookup Function HELP 7
Unable to receive OTP codes via o2 6
Mail Merge Labels (Word 2007) w/ Excel (2007) 2
Auto fill not working 2
My zip code format is lost when merging from Excel to Word... 25

Top