Collate Zip Code Article For Free

USPS Five-Digit ZIP Codes However, most of us don't know that each number in the five-digit ZIP code is significant to its destination. The first digit of your five-digit ZIP code signifies the national area, while the next two digits signify the sectional center or large city post office.

Initially, the zip code was only a two-digit number: the first denoted the city, the second denoted the state. But as the need for delivery expanded, so did the concept of the zip code. As of 1963, zip codes' numbers are determined by a few factors: the area, the regional postal facility and the local zone.

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 ZIP code 00001 is one of more than 42,000 five-digit ZIP Codes in the United States. ZIP area 00001 is located in the Dillingham Census Area, state of Alaska.

History & Development The ZIP in ZIP Code stands for Zone Improvement Plan, and it was introduced July 1, 1963, as part of a larger Postal Service Nationwide Improved Mail Service (NIMS) plan to improve the speed of mail delivery.

ZIP Codes are numbered with the first digit representing a certain group of U.S. states, the second and third digits together representing a region in that group (or perhaps a large city) and the fourth and fifth digits representing a group of delivery addresses within that region.

How To Fix Broken Zip Codes in Excel & Word Mail Merge - YouTube YouTube Start of suggested clip End of suggested clip And then insert the street. And then enter then insert the city a comma. And a space insert. TheMoreAnd then insert the street. And then enter then insert the city a comma. And a space insert. The state another space and then insert the zip. Now. If I previously preview the results.

3. Click Special, Zip Code. When the Format Cells menu pops up, select Special then Zip Code (or Zip Code + 4 if you want the extra numbers). Click OK then check it out ? your zeros have returned and will print on your envelopes as well.

So what do the extra numbers mean? 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.

The first digit in a ZIP code represents a defined group of U.S. states. The second and third digits represent a region in that group, such as a large city. To send mail, only the first five digits of the ZIP code are required.