Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)

Regex, or regular expressions, is now available in Excel beta version! This makes it SO much easier to search, match, and manipulate text. (note: currently not all beta users have access. Microsoft is slowly rolling these out.)

With regex, you can quickly find all email addresses in a list, reformat dates, or correct typos in a large dataset. You can extract phone numbers from text or change the format of thousands of rows with just a few clicks.

In this video we'll cover two new Excel functions:
▶ REGEXEXTRACT: This Excel function extracts specific text from a string using patterns called regular expressions (regex). It can find and pull the first match, all matches, or parts of the first match.
▶ REGEXREPLACE: This Excel function lets you replace parts of a text string using patterns called regular expressions (regex). This is useful for cleaning up data or making consistent changes across a dataset.

00:00 Regular Expression Regex in Excel
02:37 Extract Email Addresses with Excel REGEXEXTRACT
07:37 Extract Text Inside Parentheses with Excel REGEXEXTRACT
09:27 Extract Dates from Text with Excel REGEXEXTRACT
10:56 Extract Multiple Dates from Text in Excel
11:49 Extract Website URL from Text in Excel
14:31 Split Combined Words in Excel
14:59 Replace Leading Zeros with Excel REGEXREPLACE
16:06 Replace Special Characters with Excel REGEXREPLACE
17:30 Insert a Character at Specific Positions
18:34 RegEx Cheat Sheet
18:47 Wrap up

➡️ Join this channel to get access to perks:

🎬 LINKS to related videos:

🚩Let’s connect on social:

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel #regex #regularexpressions

[LeilaGharani]

Note: These functions are currently available to some users in the beta channel for Microsoft Insiders. Please be patient as they (often very slowly) roll out to all Office 365 users.

[dustandashes]

I have been wanting REGEX in Excel for forever. I'm retired now, but even so, I will still use it. Back when I was extracting addresses from spreadsheets for databases as a function of my job, this would have been an invaluable tool. AI, REGEX, and Excel. What a time to be alive!

[mrpage]

You're the best for keeping us apprised of all of these new functions. Thank you for all your hard work for our benefit.

[abhishekkuradia]

Finally Regex in Excel, Thank you lord and thank you lelia as always you have the most valuable and up-to-date content.

[howtolearnexcel]

Oh, so many workarounds, and now REGEX is here. I can't wait for it to be available to most users. Thank you so much for the overview.

[chrisouellet]

yeah! - RegEx is finally here!! thanks for your quick tour Leila! this is just awesome!

[brijkishorkatesaria]

Thank you Leila for your continuous effort and support

[ivanbork]

As always, you take not only a good an interesting object, but You also present it, so it´s to easy understand and use .
That being said, I´m starting to be a little critic about MS and their promises of upgrading, it often takes about a year and a half from seeing new object to the actual rollout.

[sr]

Great insight. How much I missed these functions in good old days. Anyway, better late than never. Thanks a ton for this info.

[OzduSoleilDATA]

I like this. Very helpful.
I heard of REGEX 10 years ago and it freaked me out. This video and Victor Momoh's video have put me at ease to give this a serious look.

[ConradWong]

It was such a headache to do regex extraction via VBA or Power Query routes. What a wonderful addition.

[piggybankaccountant]

I LOVE the fact that you are using AI to extract the pattern from regex! Feels like advanced excel has been unlocked to the world!

[leo]

Clear explanations and step-by-step demonstrations made what seemed like a complex topic much more understandable and manageable.Thank you for your dedication to educating and empowering others in the realm of Excel functions.

[jagexme]

Was using a combination of FIND, MID, LEN and some more. This is definitely easier.
Next is finding a way to have Excel conclude on the nature of a transaction after doing several of these evaluations. Nesting IF statements has its limitations.
Thanks for sharing. Now we wait patiently until it is available 😊

[colbyjackson]

The majority of my excel knowledge I've learned from your videos. Thank you so much. I play with excel for fun and love trying the learning your tips!

[JonLondrezos]

I had to write complicated VBA functions to use the regex libraries before. This is a game changer

[GerhardHolzer]

Tolle Hilfen - ich bin schon sehr gespannt, wann es verfügbar sein wird; und danke wie immer für das tolle Video

[jfernandez]

QUITE SIMPLE! Thank you for sharing this with us. ❤

[RinrinFibonacci]

Amazing. I wish this had existed 10 years ago as these examples are *exactly the kinds of things I would have to do regularly and figure out how to do with older functions or code. You explanations and lessons are very well put together. But this is the first one that I actually did download your very helpful lesson material. Thank you.

[jonasfermefors]

Absolutely brilliant function. Thank you, Leila, for the video. This one will save me lots of time... when I get it.