![us zip code last 4 digits us zip code last 4 digits](https://www.melissa.com/images17/idea-pc-256x256.png)
It is common to use add-on code 9998 for mail addressed to the postmaster (to which requests for pictorial cancellations are usually addressed), 9999 for general delivery and other high-numbered add-on codes for business reply mail. However, there is no uniform rule, so the ZIP + 4 code must be looked up individually for each box.
#US ZIP CODE LAST 4 DIGITS PLUS#
The add-on code is often one of the following: the last four digits of the box number (e.g., PO Box 58001, Washington DC 20037-8001), zero plus the last three digits of the box number (e.g., PO Box 12344, Chicago IL 60612-0344), or, if the box number consists of fewer than four digits, enough zeros prepended to the front of the box number to produce a four-digit number (e.g., PO Box 52, Garrett Park MD 20896-0052). In general, mail is read by a multiline optical character reader (MLOCR) that almost instantly determines the correct ZIP + 4 code from the address and-along with the even more specific delivery point-sprays a Postnet barcode on the face of the mailpiece that corresponds to 11 digits.įor post-office boxes, the general (but not invariable) rule is that each box has its own ZIP + 4 code.
![us zip code last 4 digits us zip code last 4 digits](https://fl.postcodebase.com/envelope/34432-2040.png)
Initial attempts to promote universal use of the new format met with public resistance, and today the plus-four code is not required. Postal Service began using an expanded ZIP code system called "ZIP + 4", often called "plus-four codes", "add-on codes" or "add ons." The Postal Service has a "Find a ZIP Code" feature on its website, which provides an address format that is most compatible with its optical character recognition (OCR) scanners.Ī ZIP + 4 code uses the basic five-digit code plus four additional digits to identify a geographic segment within the five-digit delivery area, such as a city block, a group of apartments, an individual high-volume receiver of mail or any other unit that could use an extra identifier to aid in efficient mail sorting and delivery. The following macro will do the trick:Īll you need to do is select the cells containing the ZIP Codes, and then run the macro.In 1983, the U.S. If you need to truncate ZIP Codes quite often, you may be more interested in a macro-based approach. You can delete the column containing the four digits, if desired. (You want your ZIP Codes to be formatted as text so that you don't lose any leading zeros.)Īt this point you have the first five digits of the ZIP Code in the original column and the last four digits (if any) in the previously empty column to the right. In the Column Data Format area, select Text.Select the Other check box, place a single dash in the box just to the right of Other, then click on Next. A ZIP+4 Code makes use of the basic five-digit code plus four extra digits to identify a geographic segment that is within the five-digit delivery area, such as a group of apartments, a city block, an individual high-volume receiver of mail, a post office box, or any other unit that could use an extra identifier to aid in efficient mail sorting.Make sure the Delimited option is selected, then click on Next.The first step of the Convert Text to Columns Wizard. Excel displays the first step of the Convert Text to Columns Wizard. Click the Text to Columns tool, in the Data Tools group. There are more than 1,539,640 North Carolina ZIP Code 5 Plus 4 in this website, including ZIP Code 5 Plus 4, Range, Record Type, Carrier Route ID, Street, Address, City Name, County FIPS, State Abbr etc.Select all the cells that contain your ZIP Codes.If you have an empty column to the right of your ZIP Codes, you can also use Excel's Text to Columns feature: Column H has now been transformed from formulas into the formula results. Make sure the Values radio button is selected.Excel displays the Paste Special dialog box. Click the down-arrow under the Paste tool and choose Paste Special from the resulting choices.Excel copies the entire column to the Clipboard. Our zip code lookup is for five digits entered and returns the city, state, population (as of the 2000 census), the total housing units declared in public information sources, the land area, water area, the latitude (positive numbers are North, negative numbers South) and longitude (negative. Copy this formula into all the appropriate cells of column H. The original code for ZIP+4 was written by us.Assuming the ZIP Codes are in column G and you added a new column H, you can enter the following in cell H3:.Insert a new column, just to the right of the existing ZIP Code column.This is a rather easy task to accomplish, since all you need to do is strip everything after the fifth digit in the ZIP Code. (Actually, the five-digit ZIP Code is a subset of the nine-digit ZIP Code.) If you are in an Excel worksheet that contains address information, you may want to convert nine-digit ZIP Codes to their five-digit equivalent. In the United States, ZIP Codes come in two formats: five-digit and nine-digit.