Add Zip Code Record For Free

To do this, select the column containing your ZIP codes, then click on the "Data" tab and select "Sort." In the "Sort" dialog box, select "Custom Sort." In the "Sort" dialog box, select "Add Level" and choose the column containing your state information. Choose to sort by state, then by ZIP code within each state.

How to fix leading zeros in zip codes in Excel in 10 seconds - YouTube YouTube Start of suggested clip End of suggested clip Yourself. So that is how to fix zip codes then put the leading zeros back into them in 10 seconds. IMoreYourself. So that is how to fix zip codes then put the leading zeros back into them in 10 seconds. I'm steve frieden with rockstar excel be sure to like and subscribe.

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.

Next, you should write out the building number and street name. The final line should have the city, state and ZIP code for the address.

Create the map chart Once you finish arranging your data, select the cells you want to turn into the map. Then on the Insert tab, go to Charts > Maps > Filled Map. Here Excel reads the ZIP codes you entered and creates a map chart based on them.

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.

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.