Convert street address to zip code

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

Rich/rerat

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.
 

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

Top