Compile Zip Code Title For Free

To do this, you can use the LEFT function. For example, if your ZIP Code is in column A, you would use the following formula: =LEFT(A1,5). This would extract the first five digits of the ZIP Code in cell A1. You can then sort by this column.

To do this, you can use the LEFT function. For example, if your ZIP Code is in column A, you would use the following formula: =LEFT(A1,5). This would extract the first five digits of the ZIP Code in cell A1. You can then sort by this column.

As of 1963, zip codes' numbers are determined by a few factors: the area, the regional postal facility and the local zone. The first number of the five-digit code signifies the region which the address is located in, a number that grows from the east coast to the west.

Follow the steps below to 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 most complete ZIP Code is a nine-digit number consisting of five digits, a hyphen, and four digits, which the USPS describes by its trademark ZIP+4. The correct format for a numeric ZIP+4 code is five digits, a hyphen, and four digits.

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.

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.