Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Excel Converting Zip plus 4 to just 5 number zip
Posted on 2013-01-07
Hi
Using Excel 2007
I have a column of zip codes that are zip plus 4. I need a formula that will change it to just the regular zip.
The data can be numbers or text.
I would like the result to be as follows.
Thanks!
Rowby
Using Excel 2007
I have a column of zip codes that are zip plus 4. I need a formula that will change it to just the regular zip.
Zip Code
93309-2156
93932-0446
92509-3600
93711-5770
The data can be numbers or text.
I would like the result to be as follows.
Zip Code
93309
93932
92509
Thanks!
Rowby
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
2
8 Comments
Active 4 days ago
Ooops I meant to split the points. GIving 100 for the link and 400 for formula.
Can a Moderator help here?
Rowby
Can a Moderator help here?
Rowby
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Suggested Courses
Course of the Month8 days, 15 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.