In this video, I will show you how to use the three new REGEX functions in Excel - REGEXEXTRACT, REGEXREPLACE, and REGEXTEST
➡️ Download File: https://www.dropbox.com/scl/fi/d68xmd0ueipjs7hheat4z/Regex-Functions-Excel.xlsx?rlkey=xw1gf33qfdphnt6uyig63x06k&dl=1
The video has a lot of practical examples that have been created to cover many useful concepts in Regex in Excel.
This comprehensive tutorial covers REGEXEXTRACT, REGEXREPLACE, and REGEXTEST, showing you how these versatile functions can transform the way you handle data in Excel.
Starting with the basics and progressing to advanced techniques, you'll discover how to:
- Extract first and last names from inconsistent data formats
- Split text and numbers without delimiters
- Process complex email patterns and multiple email addresses
- Extract specific patterns using word boundaries
- Format phone numbers using pattern matching
- Use conditional pattern matching with look-ahead and look-behind
- Work with grouped patterns for precise data extraction
Whether you're new to regex or an experienced user, this tutorial breaks down complex patterns into easy-to-understand examples. You'll learn about meta-characters, greedy operators, and grouping concepts while seeing practical applications in real-world scenarios.
The best part? You don't need to memorize patterns – learn how to leverage AI tools to help create and understand regex patterns quickly.
00:00 Intro
00:30 Intro to REGEX in Excel
04:47 Extract First and Last Name
11:28 Extract Emails from Text
19:46 Separate Text and Numbers
26:46 Word Boundary in Regex
30:22 OR Operator in Regex
33:48 Greedy Meta Characters in Regex
38:34 Grouping in Regex
42:55 Look Ahead and Look Behind in Regex
47:23 Formatting Phone Numbers using Regex
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial #SumitBansal