(Requires license for PC*MILER Spreadsheets add-on)

PC*MILER Spreadsheets includes a number of functions that allow you to retrieve location information from the PC*MILER database.

Getting 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.