View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SJC SJC is offline
external usenet poster
 
Posts: 22
Default 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.