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