NEW REGEX functions in Excel | Amazing functions for data cleaning!

In this video, we explain the new REGEX functions in excel. These functions help us clean data by specifying a pattern using the standard regular expressions code used in other programming languages such as Python for example. REGEX functions are a great addition to Excel as they will ease the data cleaning and manipulation to a great extent.

Join me in this video on a journey to discover the NEW REGEX functions in Excel!

Download Example files + REGEX Cheat Sheet:
https://tinyurl.com/yr49hxxa

Join the Microsoft Insider program:
https://insider.microsoft365.com/en-u...

Learn the TEXTJOIN function in Excel:
   • CONCATENATE vs CONCAT vs TEXTJOIN for...  


Time Stamps:
00:00 Introduction
00:16 What are Regular Expressions (REGEX)?
01:00 Extracting emails from text using REGEXEXTRACT function
04:03 Extracting URLs using REGEXEXTRACT
06:51 Extracting Hashtags from posts or tweets using REGEXEXTRACT
07:55 Extracting dates and date components and using capture groups in regular expressions
10:47 Using REGEXREPLACE function to replace and hide credit card numbers in text
12:26 Using RGEXTEST function to test for the existence of a certain pattern in a text
13:42 Download the REGEX Cheat sheet
14:12 REGEX functions availability
14:45 Conclusion

****My online Courses****
https://www.excelbonanza.com/courses/

Sign up for our Newsletter:
https://tinyurl.com/mr33kcsd

Follow us on Social Media:
Facebook: https://tinyurl.com/254eut6z
Twitter: https://tinyurl.com/ycxkjzkk
LinkedIn: https://tinyurl.com/ycym2nee
Instagram: https://tinyurl.com/3mdpbdwa
TikTok: https://tinyurl.com/p36wae4k
Telegram: https://tinyurl.com/escuvwj9
Website: https://tinyurl.com/twtnwuv9

#regex #regularexpressions #regularexpression #exceltutorial #excelfunctions #excelfunction