Excel RegEx Support For Pattern Matching - Episode 2642

Подписаться 155 тыс.

Просмотров 2,7 тыс.

50% 1

Microsoft Excel Tutorial: Excel Adds RegEx Support for Pattern Matching in Excel.
🎥 Unlocking the Power of RegEx in Excel: New Features Explained! 📊
Hey Excel enthusiasts! 🌟 In today's video, we're diving into an exciting new feature: RegEx support in Excel for pattern matching. If you enjoy exploring new Excel functionalities, this is a must-watch! Don't forget to Like this video to help it reach more people. 👍
🔥 What's New? 🔥
Excel has introduced three powerful RegEx functions: RegExTest, RegExReplace, and RegExExtract. These functions are set to revolutionize how we handle data patterns. Plus, there are updates to XLOOKUP and XMATCH functions that now include RegEx capabilities! Let's explore how these tools can make your data tasks easier and more efficient.
🔍 Understanding RegEx Functions 🔍
RegExTest: Quickly determine if a pattern exists within your text.
RegExExtract: Extract specific patterns from your data.
RegExReplace: Replace patterns with desired characters or symbols. Perfect for anonymizing sensitive information like account numbers or patient IDs.
📈 Practical Applications 📈
We'll walk through real-world examples, like filtering data with digits, extracting specific formats, and masking sensitive data. These demos will help you see the immense potential RegEx brings to your Excel toolkit.
📝 Bonus Tips & Tricks 📝
Discover how to use these functions with the FILTER function and how to handle multi-part patterns. Plus, learn some insider tips on using RegEx efficiently in Excel. Whether you're new to RegEx or looking to refine your skills, this video has something for everyone.
💬 Join the Conversation! 💬
If you have questions or insights, drop them in the comments below. Let’s learn together! And don’t forget to visit MrX.CL/gpt to explore over 2,500 Excel tutorials and find answers to your specific questions.
Thanks for watching! Remember to Like, Subscribe, and Ring the Bell for more Excel tips from MrExcel. See you next time! 🎉
#Excel #RegEx #PatternMatching #ExcelTips #MrExcel #DataAnalysis #ExcelFunctions #Tutorial #LearnExcel
To download the workbook from today: www.mrexcel.com/youtube/LWcqR...
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
Table of Contents
(0:00) Intro to RegEx in Excel
(0:10) MrExcel GPT to answer your Excel questions
(0:26) What is RegEx?
(0:57) REGEXTEST function in Excel
(1:21) Using REGEXTEST inside of FILTER in Excel
(1:34) REGEXEXTRACT function in Excel
(2:28) REGEXREPLACE function in Excel
(2:50) REGEX in Excel lookup
(3:00) Excel RegEx returning multiple groups of data
(3:56) Extracting City and State for each Stuckey's Restaurant
(5:13) Hiding all but last 4 digits of Social Security Number
(6:02) Wrap-up
This video answers these common search terms:
excel regex tutorial
how to use regex in excel
regex functions in excel 2024
excel pattern matching with regex
new regex features in excel
excel regex examples
using regextest in excel
excel regexreplace function
extracting data with regex in excel
excel tips for pattern matching

Опубликовано:

14 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@roywilson9580 Месяц назад

Thanks for the video, I can't wait to get my hands on the Regex functions, having already used them in python and can see very many use cases with Excel in data cleansing and so on.

@vinamrachandra9611 Месяц назад

Grep, short for “global regular expression print”, was a command, I first encountered in Unix, used for searching and matching text patterns in files contained in the regular expressions.

@mangezable Месяц назад

Fascinating! I held a lecture on regex to my colleagues two days ago, so this upload was a nice coincidence. Will be interesting to see this in Excel! 😊

@daXcel7448 Месяц назад

Thanks for the video. Flash Fill too does a pretty good job in these situations.

@OmisileKehindeOlugbenga Месяц назад

Awesome. RegEx now in Excel.

@facthello2814 Месяц назад

I work for excel

@Corey_Bee Месяц назад

I think validating a list of email addresses would be a great use case. The precise requirements can be a bit confusing if you go for perfection, but once you settle on the requirements, regex is a great way to validate against them.

@Excelambda Месяц назад

Great Video!! Do not have the update yet to check. 2:25 the difference could be : one way : all the digits should have at least one occurrence...and since there are digits with no occurrence...no match ; the other way zero or more occurrences

@vinamrachandra9611 Месяц назад

I tried with B 90210 and used =REGEXEXTRACT(H13,"\d*",1) RESULT spilled over 4 rows with first, second, and fourth returning blank and third returning 90210. Looks like REGEXTRACT is returning blank if pattern is not matched. That is why =REGEXEXTRACT(H13,"\d*") works only when number is at the start of the string. =CONCAT(REGEXEXTRACT(H13,"\d*",1)) is working. Either a bug or poor design.