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


"SJC" wrote in message
...
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.