Easy Data Cleaning with NEW Regex Functions in Excel

NOTE: At the time of this video being published, the 3 new REGEX functions are in beta and only available on the Beta Channel of Microsoft 365 for Windows or Mac. They are only available to a portion of users on the beta channel.

🔗LINKS

00:00 Introduction
00:26 REGEXTEST
02:00 REGEXEXTRACT
04:00 REGEXREPLACE
05:10 REGEX with Data Validation
06:50 REGEX with Conditional Formatting
07:50 Getting help with REGEX

[ExcelCampus]

The new functions are currently in beta and only available to a portion of users on the Beta Channel for Microsoft 365. Leave a comment and let us know if you have any questions or how you will be using the new features. 🙂

[floreagabriel]

God bless Microsoft for introducing, at last, regular expressions, the formulas to extract string pattern were truly monstrous.

[Loraxgood]

So much that can be done in Excel. Thanks for sharing.

[ZijZijnZijnZoons]

I would use the conditional formatting along with the regex functions to validate data that I might enter or import from an external source.

[pfpwkqk]

I extract information from a bank description that includes the deposit date from the deposit ticket, the store#, and the bag# the deposit is in. I use Mid/Find right now, but I think this will be easier and it won't matter how many characters are in the cell. Thank you!!

[liquidapathy]

Absolutely amazing and informative video. I absolutely think i can find uses for this at my job.

[MAKROAPLIKACJE]

Thank you Jon for a very useful video! 💚 I'm a VBA programmer and I hope that these functions will soon be available from the WorksheetFunction object. In recent days, a lot has been written about the fact that Microsoft will block support for regular expressions from VBA in 2027. However, this wouldn't be a big problem if we had access to these three new functions 🙂.

[IvanCortinas_ES]

Thank you for this tutorial Jon. A true revolution. It's time to apply it, because it has a lot of potential.

[oufnacdj]

Amazing. Thank you. Never seen regret before and have written the complicated nested excel formulas like you showed. It’s great things coming at the same time that the AI chat bots are available to help write the patterns. Thank you again.

[jmklei]

I have wanted to look for specific bits of data in my values on several occasions, but not able to in the past. It would've been outside my scope of learned formulas. This will be very helpful. Thanks for sharing.

[learningwithmaliha]

Amazing functions, explained quite in detail. Thank you for making this awesome video.

[jackcurl]

Impatiently awaiting availability of these and several other of the new functions. Any idea of anticipated release date? I'm not any kind of insider so it's all black box to me :::sigh::::

[ksumar]

Smart feature, when will they be rolling it out? I try on my Excel Office 365 and there was an update so I was excited that maybe REGEX will be included. But not quite on my Excel yet. I need to be a XL Guru like you John. This is useful when you download Customer/Supplier records during a huge data migration exercise to be uploaded to a new system and wish to correct the say the Telephone format or in UK we have Nat Ins Number which HAS to be in AA-12-23-34-X format!

[williamhougland-cdot]

conditional formatting is a memory hog (or it used to be, as I quit using it)...

[deviationfluxer]

I dont get the REGEX options in the Fx (Insert Functions) button. Is this version specific? How do i get that feature?