Spreadsheets: Get Location Information (Names)
PC*Miler Spreadsheets includes a number of functions that allow you to retrieve location information from the PC*Miler database.
Get the City Name/State/County from a Location
=CityNameWithCounty (placeName)
CityNameWithCounty takes a PC*Miler location (city-state, postal code, six-digit Canadian Postal Code, PC*Miler Worldwide international postal code, SPLC, PC*Miler custom name) and returns the city name with state and county. Any place name, postal code, or SPLC in the PC*Miler or database may be used. Returns -1 if the PC*Miler place you entered is invalid.
