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