EXCEL PRO TIP: Zip Codes & Phone Numbers

For access to all pro tips, along with Excel project files, PDF slides, quizzes and 1-on-1 support, upgrade to the full course (75% OFF):
courses.excelm...
FULL COURSE DESCRIPTION:
This course is NOT an introduction to Excel.
It's not about 101-style deep dives, or about showing off cheesy, impractical "hacks".
It's about featuring some of Excel's most powerful and effective tools, and sharing them through crystal clear demos and unique, real-world case studies.
We'll cover 75+ tools & techniques, organized into six categories:
-Productivity
-Formatting
-Formulas
-Visualization
-PivotTables
-Analytics
Demos are self-contained and ranked by difficulty, so you can explore the content freely and master these tools and techniques in quick, bite-sized lessons.
Full course includes LIFETIME access to:
-10+ hours of high-quality video content
-Downloadable PDF eBook
-Excel project files (including data sets & solutions)
-1-on-1 expert support
-100% satisfaction guarantee (no questions asked!)
Happy analyzing!
-Chris (Founder, Excel Maven)

[@wayneedmondson1065]

Hi Chris.. thanks for the reminder of the "Special" number formatting category. Usually I fly by that choice to one of the other options or just build a custom format. Will remember to check those out in the future. Thanks and Thumbs up!

[@darrylmorgan]

Boom!One of my Favourite Tips from the Course Thank You Chris :):)

[@Propelledfeline]

How do I get rid of the extra +4 on zip codes quickly? I work with data that contains both zip code and zip code +4 but I need it all to be just zip code.