Excel Guides

Shortening ZIP Codes in Excel

If you have a list of ZIP codes in Excel, you may want to shorten them to just the first five digits. This can be useful if you are trying to create a map of ZIP codes or if you need to save space in your spreadsheet.

There are a few different ways that you can shorten ZIP codes in Excel. One way is to use the LEFT function. This function allows you to extract a certain number of characters from the left side of a string of text. For example, if you have a ZIP code that is 9 digits long, you can use the LEFT function to extract the first 5 digits like this:

=LEFT(A1,5)

This formula will take the value in cell A1 and extract the first 5 characters from it. If the value in cell A1 is "123456789", the result of this formula will be "12345".

Another way to shorten ZIP codes is to use the RIGHT function. This function works similarly to the LEFT function, but it extracts characters from the right side of a string instead of the left side. So, if you have a 9-digit ZIP code in cell A1, you could use the RIGHT function to extract the last 4 digits like this:

=RIGHT(A1,4)

If the value in cell A1 is "123456789", the result of this formula will be "6789".

You can also use the MID function to extract any middle portion of a string. For example, if you have a 9-digit ZIP code in cell A1, you could use the MID function to extract the first 3 digits and last 4 digits like this:

=MID(A1,1,3)&"-"&MID(A1,6,4)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.