(North America only; must be licensed for streets data)
=AddressToLatLongWS takes an address and returns the latitude/longitude.
Returns -1 if the place name you entered is invalid.
Syntax
=AddressToLatLongWS (Address)
Arguments
| Argument | Description | Required? | Values |
| address | An address for which you want to retrieve a latitude/longitude. | yes | A ZIP/Postal Code or city/state, followed by a street address. Separate the two with a comma or a semicolon. Examples: Perkasie PA;238 Pennland Farm Drive 08540, 20 Nassau Street Liverpool NY,305 Oswego Street |