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. 🙂
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.
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 🙂.
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.
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!!
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::::
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!
Thank you for providing the example, Karim! That does sound like a useful scenario for regex. I'm not sure when they will be rolling out of beta, but hopefully soon. 🤞 Thanks again and have a nice weekend! 🙂
You need to be on the Beta Channel of Microsoft 365 and be lucky enough to have been selected to get these functions. They'll eventually roll out to all 365 users.
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. 🙂
So much that can be done in Excel. Thanks for sharing.
God bless Microsoft for introducing, at last, regular expressions, the formulas to extract string pattern were truly monstrous.
Absolutely amazing and informative video. I absolutely think i can find uses for this at my job.
Thank you for your feedback! 😀
Thank you for this tutorial Jon. A true revolution. It's time to apply it, because it has a lot of potential.
Thank for your feedback, Ivan! 😀
I would use the conditional formatting along with the regex functions to validate data that I might enter or import from an external source.
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.
Thanks! I'm happy to hear these will reduce complexity in your formulas. 🙂
Fantastic
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 🙂.
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.
It's great to hear that the new functions will be helpful. Thanks James! 🙂
Amazing functions, explained quite in detail. Thank you for making this awesome video.
Thanks Maliha! 🙂
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!!
Any video on patterns
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::::
Does anyone here have any idea when these will be released to General Availability?
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!
Thank you for providing the example, Karim! That does sound like a useful scenario for regex.
I'm not sure when they will be rolling out of beta, but hopefully soon. 🤞
Thanks again and have a nice weekend! 🙂
Great tutorial, thanks Master! 😉
Thanks! 🙏
conditional formatting is a memory hog (or it used to be, as I quit using it)...
I dont get the REGEX options in the Fx (Insert Functions) button. Is this version specific? How do i get that feature?
You need to be on the Beta Channel of Microsoft 365 and be lucky enough to have been selected to get these functions. They'll eventually roll out to all 365 users.