Extend Zip Code Log For Free

An extended ZIP+4 code was introduced in 1983 which includes the five digits of the ZIP code, followed by a hyphen and four additional digits that reference a more specific location.

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.

United States ZIP codes are five numerical digits long. ZIP+4 codes, also known as add-on or plus-four codes, include four additional digits that identify a geographic segment within a ZIP code delivery area.

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.

What is the four-digit extension? It represents a specific delivery route within that overall delivery area. For PO boxes, the four-digit extension usually includes the PO box number. Including the last four digits means mailings will arrive to their intended destination faster, as well as discounts on bulk mailings.

The letters ZIP is an acronym for Zone Improvement Plan. The letters are written properly in capital letters. The word ZIP was chosen to suggest that the mail travels more efficiently, and more quickly, when senders use it.

All addresses in a territory have a common post code. The postal code extension identifies subdivisions in each post office territory.