Draft Zip Code License For Free

A United States postal code, for example, might be either five digits or five digits followed a hyphen (dash) and another four digits (12345-1234). If you are validating US postal codes, allow for both conditions. The following rule validates a field that can be five digits, five digits + dash + 4 digits, or blank.

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.

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.

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.

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.

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

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.

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.