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
