Convert street address to zip code

  • Thread starter Thread starter SJC
  • Start date Start date
S

SJC

I recently acquired a database with no zip codes. I have street addresses,
city, and state. Is there anyway of coverting the street addresses to a zip
code in excel? I am able to convert to zip from city and state, but for the
majority of entries, there are multiple zip codes for one city. So, I am
thinking I need a conversion tool that uses the street address, as well as
city and state. Thanks for any help.
 
SJC,
You will need to purchase a third party program that uses ZIP+4, or will use
addresses reference.

You should check the USPS website www.usps.gov under Services/ZipCodes. They
offer some programs for sale. Or do a google search for zip code software or
databases.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


I recently acquired a database with no zip codes. I have street addresses,
city, and state. Is there anyway of coverting the street addresses to a zip
code in excel? I am able to convert to zip from city and state, but for the
majority of entries, there are multiple zip codes for one city. So, I am
thinking I need a conversion tool that uses the street address, as well as
city and state. Thanks for any help.
 
Back
Top