Takes a location string (either XML, lat;long, or address) and returns the address component as a string. Reverse geocodes as necessary.
= LOCATIONTOADDRESS (location)
location |
String containing the location in any of 3 formats: an XML location string, a latitude and longitude separated by a semicolon, or a street address. |
String
Returns the address component as a string.
Example |
Returns |
= LOCATIONTOADDRESS(GetBrowserLocation()) |
Returns address component as a string. |
= LOCATIONTOADDRESS("2870 Zaker Rd, San Jose CA")
|
Returns address component as a string. |
= LOCATIONTOADDRESS("37.23;-121.55")
|
Returns address component as a string. |
|
|