About this episode
This episode discusses how to use Regular Expressions (REGEX) in Excel to manage messy data and improve reporting efficiency.
Messy, unstructured data. It slows reporting, creates errors , and tests everyone's patience. Right ? This episode breaks down how the new Regular Expressions (REGEX) work and how they help you find patterns in unstructured text, from email addresses to dates and hidden white space. You will learn: w hat REGEX is and why it matters for accountants and analysts h ow to use REGEXEXTRACT, REGEXTEST and REGEXREPLACE w hen to combine REGEXTEST with FILTER for smarter analysis h ow REGEX now works inside XLOOKUP and XMATCH w ays to manage white space and non-standard characters w hy building a reusable pattern library will save time . Programmers have been using REGEX patterns for decades, but they ' ve only just come to Excel. The good news is Excel's new REGEX functions give finance teams a practical way to take back control. Listen now to help improve your Excel skills. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants . For more, check out the accompanying YouTube video of this episode. R ead more of Neale's…
People in this episode
Host: Neale Blackwood CPA
Topics covered
- data management
- REGEX
- Excel functions
- accounting
- data analysis
Keywords
- REGEX
- Excel
- data patterns
- data analysis
- accountants
- XLOOKUP
- FILTER
Mentioned in this episode
Organizations: CPA Australia
Books & works: Advanced Excel Reporting for Management Accountants
More episodes of Excel Tips
- Template tips to boost workflows · May 1, 2026 · 8 min
- Increment dates easily in Excel · April 1, 2026 · 7 min
- Build Better Excel Models · February 2, 2026 · 12 min
- Smarter, faster, easier: Here's what's new in Excel · January 1, 2026 · 14 min
- Unlock 7 underused Excel features you still need today · December 1, 2025 · 16 min
- How to simplify complex calculations with custom functions · November 3, 2025 · 8 min
Explore listener stats, chart rankings, contacts and more on the Excel Tips podcast page.