REGEX in Excel - Lesson 5 - Advanced Unicode Character Classes

Learn Regex (regular expressions) in Excel - In this lesson, we go over some advanced unicode property classes so that you can pull out things like upper vs lower case letters and currency symbols 📺 Watch the Full Series: 🔗    • Regex in Excel 101 - Beginner to Advanced   This video is part of the "Regex in Excel 101: Beginner to Advanced" free course. If you want to drop convoluted, nested text formulas and master Excel's new native Regular Expression functions, check out the full playlist. In this course, we cover: The essential syntax of Regular Expressions (Classes, Quantifiers, Anchors) Using REGEXTEST, REGEXEXTRACT, and REGEXREPLACE Advanced techniques like Lookarounds and Recursion Optimizing patterns for high-performance spreadsheet calculation ⏱️ Chapters / Timestamps: 0:00 - Intro 1:25 - Unicode Letters 2:31 - Unicode Subsections 5:48 - Extract currencies 8:07 - Clean corrupted text 🛠️ Resources Mentioned: Test your patterns: https://regex101.com/ (Remember to set the flavor to PCRE2!) Regex Golf game: https://alf.nu/RegexGolf 🔗 Excel file link and cheat sheet: https://1drv.ms/x/c/d4e2a03d6d6e17b7/... If you found this helpful, a like or subscribe is hugely appreciated and helps the channel grow. Drop any questions or formula issues in the comments below!