Easy Data Cleaning with NEW Regex Functions in Excel
Excel Campus - Jon Excel Campus - Jon
589K subscribers
36,362 views
546

 Published On May 30, 2024

Discover the magic of Excel Regex Functions! Learn how to use Regular Expressions to streamline data cleaning, extract specific information, and easily perform complex text manipulations. This tutorial will show you how to harness the full potential of Regex in Excel. DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/functions...

NOTE: At the time of this video being published, the 3 new REGEX functions are in beta and only available on the Beta Channel of Microsoft 365 for Windows or Mac. They are only available to a portion of users on the beta channel.

🔗LINKS

🔎 Get free weekly Excel tips: https://www.excelcampus.com/newsletter/

💡 Free 60-minute Excel training session: https://www.excelcampus.com/blueprint

📖 Join Our Comprehensive Excel Training Program: https://www.excelcampus.com/elevate

00:00 Introduction
00:26 REGEXTEST
02:00 REGEXEXTRACT
04:00 REGEXREPLACE
05:10 REGEX with Data Validation
06:50 REGEX with Conditional Formatting
07:50 Getting help with REGEX

show more

Share/Embed