Adjust Zip Code Record For Free

Any proposal for change must be submitted in writing to the district manager. The district manager is to work with the local postal managers, headquarters delivery, and headquarters Address Management System to evaluate the request and determine if an accommodation can be made.

Now your nine-digit ZIPs are shortened to five-digit zip codes....Shorten to Five DigitsInsert 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.

To do this, you can do one of two things:Format the column as Text. Select your data range and press Ctrl+1 to launch the Format > Cells dialog. On the Number tab, click Text.Use the apostrophe character. You can type an apostrophe (') in front of the number, and Excel will treat it as text.

Shorten ZIP Codes in ExcelSelect the entire column H.Press Ctrl+C. Excel copies the entire column to the Clipboard.Display the Home tab of the ribbon.Click the down-arrow under the Paste tool and choose Paste Special from the resulting choices. Excel displays the Paste Special dialog box. (See Figure 1.)Oct 2, 2012

The 9-digit ZIP Code consists of two sections. The first five digits indicate the destination post office or delivery area. The last 4 digits represent specific delivery routes within delivery areas. ZIP plus 4 codes assist the USPS in effectively sorting and distributing mail.

Your ZIP+4 is a basic five-digit code with four digits added as an extra identifier. It helps to identify a geographic segment within the five-digit delivery area, such as a city block, a group of apartments, an individual high-volume receiver of mail, or a post office box.

=LEFT (A2, 5) and press Enter on the keyboard. The function will return the first 5 characters from the cell.