TRUE if the zip code is a Zip Code Tabulation area ( learn more). The longitude of the zip code ( learn more). The latitude of the zip code ( learn more). The 5-digit zip code assigned by the U.S. Simple: A single CSV file, concise field names, only one entry per zip code.Accurate: Aggregated from official sources and precisely geocoded to latitude and longitude.Useful fields: From latitude and longitude to household income.Comprehensive: 41,705 unique zip codes including ZCTA, unique, military, and PO box zips.Includes data from 2020 Census and 2021 ACS! Up-to-date: Data updated as of February 13, 2023.TIP: If a Canadian city, Canadian postal code, or SPLC is entered in the function, it will return the city/state without a code. FullName returns -1 if the PC*MILER place you entered is invalid. Any place name, postal code, or SPLC in the PC*MILER database may be used (Canadian Postal Codes included in PC*MILER, and international postal codes are additionally available for PC*MILER Worldwide customers). Getting the Full ZIP/Postal Code and City Name =FullName(CityNameOrZipCode)įullName returns the postal or SPLC code, city/state abbreviation, and county name corresponding to the given location. Click OK to close the dialog (the selected code won’t be entered, this must be done manually). Click OK to close the dialog (the selected code won’t be entered, this must be done manually).Ĭlick the Add-Ins tab and select PC*MILER Location Lookup…, then enter a city/state (example: ‘Montreal, QC’) and click Lookup. All postal codes will be listed for the entered location. In Excel 2003, select Insert menu > PC*MILER Location Lookup…, then enter a city/state (example: ‘Montreal, QC’) and click Lookup. The steps to access the Location Lookup vary depending on the version of Excel you are using: However, Canadian and Worldwide codes can be found using the Location Lookup dialog. nor SPLC can be derived from this function. For example, the following Excel command will return TRUE if cell B2 contains a valid postal code and FALSE if it does not: =NOT(EXACT(-1,ZIPCode(B2))) The ZIPCode function can be used to test if a given number is a valid postal code. ZIPCode returns a -1 if the place name you entered is invalid. The place name is a city with a state abbreviation, surrounded by quotation marks (e.g. ZIPCode returns the postal code corresponding to any U.S. Getting the ZIP/Postal Code from a City Name =ZIPCode("City,State") ZIP codes representing centralized areas are valid with this function, as are international postal codes for PC*MILER Worldwide customers.) CityName returns -1 if the postal code you entered is invalid. (Canadian Postal Codes, SPLC, and 3-digit U.S. Getting the City Name from a ZIP/Postal Code =CityName(ZIPCode)ĬityName returns the city name and state or country abbreviation corresponding to the given postal code. PC*MILER Spreadsheets includes a number of functions that allow you to retrieve location information from the PC*MILER database. Use Excel's Insert Function option to easily call PC*MILER functions and insert your arguments. (Requires license for PC*MILER Spreadsheets add-on. Solution home PC*MILER User Guide PC*MILER Spreadsheets Using Spreadsheets: Getting Location Information (Postal Codes)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |