12
3
Given a column of street addresses with city and state but no zip in a spreadsheet, I'd like to put a formula in a second column that yields the ZIP code. Do you know a way to do this?
I'm dealing with US addresses, but answers pertaining to other countries are interesting, too.
UPDATE: I guess I'm mostly hoping that there's a way to do this in Google Spreadsheets. I realize that you need to access a vast ZIP code database to do this, but it seems to me that such a database is already inside Google Maps. If I put an address in there without ZIP code, I get back an address with ZIP code. If Maps can do that lookup, maybe there's a way to make it happen in Spreadsheets, too.
Little known fact, ZIP codes are only needed to make your mail delivery faster. That use is less applicable today than when they were first introduced (in 1968) because the USPS now scans typed addresses and looks up the ZIP for you if it is missing. If you don't provide one then the USPS will use their system to provide it (and best of all their is no extra cost with that). Also, ZIP codes ARE US specific. Most places have them but they are called postal codes everywhere else. – krowe – 2015-07-23T13:23:06.677
Related to @ChrisF's answer, what region are you in? – JMD – 2010-01-06T16:28:42.717
I didn't realize that the term "ZIP" applied outside the US. Anyway, I've specified now. – Isaac Moses – 2010-01-06T19:14:39.027