(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

ArgumentDescription
Required?
Values
addressAn 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