Itemize Zip Code Release For Free

ZIP codes have nothing to do with the lines that define a county. One ZIP code could include addresses in multiple counties and a single county might include hundreds of ZIPs!

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.

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. If that is not possible, the ZIP Code, including the ZIP+4 Code, may be placed below the city/state information.

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.

These should be placed on the same line as the street address. Place the city, state, and ZIP Code in that order on the last line. This must be the last line. Never place an ?attention line,? telephone number, or other entries after the ZIP Code 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.