REGEX in Excel 101 - Lesson 1 - Character Classes

Learn Regex (regular expressions) in Excel - In this lesson, we cover an introduction to character classes and ranges.

📺 Watch the Full Series:
🔗 https://www.youtube.com/playlist?list=PLMEzb9_xonjoOGHSypSdCkjyEa2lJvzbh

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 - Introduction
0:39 - Resources
1:45 - Exact matches
2:05 - Basic Character Classes
2:38 - Digits
3:39 - Inverse of a class
4:06 - Word letters
4:21 - Whitespace
4:35 - Word boundaries
5:25 - Grapheme Cluster
6:25 - Excel examples
7:03 - Ranges and square brackets
9:52 - Regex Golf challenges

🛠️ 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/IQCna6w1rVZwR74ZF0mzcrLeAQbaxbAg4f90ovHKhwmYbqg?e=9hyajq

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!

Видео REGEX in Excel 101 - Lesson 1 - Character Classes канала Excel & Finance