Using Coordinates for Reverse Geocoding

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 format

• Error: 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)