Draft Zip Code License For Free

In 1983, the zip + 4 format we now use (e.g., 60601-1635) was introduced to support delivery to densely populated areas. The first three digits before the hyphen identify the sectional center or large city. The second two classify the post office facility or delivery area.

The correct format for a numeric ZIP+4 code is five digits, a hyphen, and four digits. The first five digits represent the 5-digit ZIP Code; the sixth and seventh digits (the first two after the hyphen) identify an area known as a sector; the eighth and ninth digits identify a smaller area known as a segment.

It is preferred that all City, State, and ZIP Code information be on a single line.

Shorten to Five Digits Insert a new column to the right of your current zip code column. Type or copy and paste =LEFT(C2,5) , replacing C2 with your cell's identifier. Drag the formula down the rest of your column.

The first three digits of a ZIP Code together usually indicate the central mail processing facility, also referred to as a sec center or sectional center facility to which that ZIP Code belongs. This facility is the mail sorting and distribution center for a zone or area.

Valid US ZIP Code Pattern US ZIP code (U.S. postal code) allows both the five-digit and nine-digit (called ZIP + 4) formats. E.g. a valid postal code should match 12345 and 12345-6789, but not 1234, 123456, 123456789, or 1234-56789.

These last 4 digits represent specific delivery routes within delivery areas. This extra detail means an even more precise matching to a more granular level. It could represent a handful of houses on one side of a street, or even a single building that receives a high volume of mail.