Can you convert an address to a zip code in a spreadsheet?
Fresh3 days ago
Mar 15, 202657579 viewsConfidence Score0%
0%
Problem
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…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Can you convert an address to a zip code in a spreadsheet?
Low Risk
Google spreadsheets has a series of functions for external data. If you can find (or create) a site which does the lookup by passing parameters, you could put a formula similar to this in: This is a hypothetical idea. The concatenate, importData and…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix