| 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. |
| 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) | |||
Threaded Mode
