Рет қаралды 216
In this video, I'll show you how to use the new REGEX Excel Functions to clean and extract data. You'll learn how the REGEXTEST, REGEXEXTRACT, and REGEXREPLACE functions work.
🚀Regex Guide:
excelkid.com/regex-in-excel/
🎓 LEARN MORE in my Excel tutorials: excelkid.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love.
🚀 Get DataFX Free Function library:
excelkid.com/add-ins/
Regular expressions are now available in the Excel beta version.
Chapters:
00:00 Intro
00:11 Excel REGEXEXTRACT Function
01:01 REGEXTEST Function
01:27 REGEXREPLACE Function
#exceltips #excel #regex