Master your messy data

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:

• what REGEX is and why it matters for accountants and analysts

• how to use REGEXEXTRACT, REGEXTEST and REGEXREPLACE

• when to combine REGEXTEST with FILTER for smarter analysis

• how REGEX now works inside XLOOKUP and XMATCH

• ways to manage white space and non-standard characters

• why 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.

Read more of Neale's Excel articles on INTHEBLACK.

Loving this content?

Don't forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community.

Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel.

And don't forget to subscribe to the channel.

You can find a CPA at our custom portal on the CPA Australia website.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance and accounting:

With Interest

INTHEBLACK

Excel Tips

INTHEBLACK Out Loud

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au