| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert street address to zip code
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert street address to zip code
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| arrange excel by street address instead of alphabetically by name | Excel Worksheet Functions | |||
| Relpace entire address with street name only, searching with wildc | Excel Worksheet Functions | |||
| How do you remove the numbers from a street address in EXCELL? | Excel Worksheet Functions | |||
| how do I convert cell 'Street,#' to '# Street' these are addresse | Excel Worksheet Functions | |||
| outlook 3 line street address | Excel Discussion (Misc queries) | |||
Linear Mode
