Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to change 9-digit zip codes to 5 digits in Excel?
Excel has two specialised numerical forms for postal codes, referred to respectively as Zip Code and Zip Code + 4. In the event that they do not fulfil your requirements, you are free to design your own bespoke format for postal codes. If you have an Excel spreadsheet that includes address information, you may wish to convert 9-digit ZIP Codes to their 5-digit counterpart. This can be done by using the "Convert Nine Digit ZIP Code to Five Digit ZIP Code" function.
There are two different variations of the ZIP Code used in the United States: the 5-digit version, and the 9-digit version. In point of fact, the 5-digit ZIP Code is a subset of the more comprehensive 9-digit ZIP Code.
Step 1
Simply removing anything in the ZIP Code that comes after the fifth number is all that is required to complete this operation, which makes it a rather simple one to carry out. Continue in the same manner.
Step 2
You are welcome to adopt the uncomplicated approach that is outlined in the following paragraphs; but, if you do so, you will only be able to remember the first five digits of the nine-digit zip code.
=LEFT(A2,5)
To get the desired outcome, you may use the formula that was just shown to you.
Step 3
Following the execution of the algorithm and the pressing of the enter key, you will be presented with the unique 5-digit zip code.
Step 4
After that, slide the fill handle to the cells in which you desire to apply the aforementioned formula, and after you have done so, you will see that the first five values have been subtracted from the total. picture that is shown on the bellow
Conclusion
In this tutorial, we used a simple example to show how you can change 9‑digit zip codes to 5‑digit zip codes in Excel.
1K+ Views
