Have latitude/longitude coordinates instead of addresses? Use the CombineCoords helper function to convert them into a format the Address Formatter can reverse geocode into full addresses.
CombineCoords Function #
Combines latitude and longitude into a lat,lng string.
Usage #
=CombineCoords(latitude, longitude)
Returns: "40.7128,-74.006" or an error message
Supported Formats #
| Format | Latitude Example | Longitude Example |
|---|---|---|
| Decimal | 40.7128 |
-74.0060 |
| With direction | 40.7128 N |
74.0060 W |
| DMS | 40ยฐ 42' 46" |
74ยฐ 0' 21" W |
| Compact DMS | 404246 |
0740021 |
Direction letters: N/S for latitude, E/W for longitude (converts to +/-)
Examples #
| Latitude | Longitude | Result |
|---|---|---|
40.7128 |
-74.0060 |
40.7128,-74.006 |
40.7128 N |
74.0060 W |
40.7128,-74.006 |
40ยฐ 42' 46" |
74ยฐ 0' 21" W |
40.7128,-74.0058 |
404246 |
0740021 |
40.7128,-74.0058 |
Errors #
Returns descriptive messages instead of #VALUE!:
Error: Latitude 91 out of range (-90 to 90)Error: Longitude 'abc' is not a valid coordinate formatError: Latitude is empty
With Reverse Geocoding #
Put the result in your Incomplete Address column, then run Address Formatter:
| Latitude | Longitude | Input Address |
|---|---|---|
| 40.7128 | -74.0060 | =CombineCoords(A2,B2) |
