PC*MILER Web Services Spreadsheets
A guide to using PC*MILER Web Services Spreadsheets, an add-in for Microsoft Excel.
=ZIPCodeWS returns the ZIP or postal code corresponding to any U.S. place name. The place name is a city with a state abbreviation (e.g. Austin, TX). Th...
Wed, 26 Mar, 2025 at 12:08 PM
=CityNameWS returns the city name and state or country abbreviation corresponding to the given ZIP or postal code. The country must be specified. Syntax...
Wed, 26 Mar, 2025 at 12:08 PM
=FullNameWS returns the ZIP/Postal code or SPLC code, city/state abbreviation, and county name corresponding to the given location. Syntax =FullNameWS(...
Wed, 26 Mar, 2025 at 12:08 PM
=CityNameWithCountyWS takes a location and returns the city name with state and county. Syntax =CityNameWithCountyWS(location) Arguments Argument...
Wed, 26 Mar, 2025 at 12:08 PM
=CityToLatLongWS takes a location and returns the latitude/longitude of a point central to the location. Syntax =CityToLatLongWS(location) Argumen...
Wed, 26 Mar, 2025 at 12:08 PM
=LatLongtoCityWS returns the name of the closest city to the latitude/longitude entered. Syntax =LatLongtoCityWS(LatLong) Arguments Argument ...
Wed, 26 Mar, 2025 at 12:08 PM
=AddressToLatLongWS takes an address and returns the latitude/longitude. Syntax =AddressToLatLongWS (Address) Arguments Argument Description Re...
Wed, 26 Mar, 2025 at 12:08 PM
=LatLongToAddressWS takes a latitude/longitude and returns the address. Syntax =LatLongtoAddressWS(LatLong) Arguments Argument Description ...
Wed, 26 Mar, 2025 at 12:08 PM