ฝัง
- เผยแพร่เมื่อ 26 ก.ย. 2024
- Learn about the new set of REGEX functions being released into Excel and integrated into existing functions.
File Download Link:
www.bcti.com//...
Leila's REGEX video on her TH-cam channel (XelPlus):
• Introducing REGEX Exce...
Original Password Checking project video:
• Microsoft Excel - Pass...
00:43 Explanation and Examples of Use (Leila's Great REGEX Video)
01:11 Recap of an Earlier Project
01:37 XLOOKUP and XMATCH using REGEX
02:01 Creating a REGEX Test for Password Complexity
02:54 Using ChatGPT to Generate Our Pattern
04:06 Dynamic Response Headings
04:40 Download File and Examine Special Character Issues
Yes Sir. We are following her and many others. They are all very helpful. I have learnt so much from all of them.
I have Excel 2021 but MS 365 is better with too many superior functions.
You are so kind for suggesting following Leila. Actually, Ive been following her since 3 or more years ago. Your channel was the real catch for me. Thank you both.
I've been working with Leila for 7 years and consider her a good friend. She is absolutely THE BEST on TH-cam when it comes to Excel and all things related. For you to say that I'm "the real catch" is extremely high praise. You are so kind. Thanks for watching.
I’ve seen a couple of other videos on this new REGEX function and it sure does look interesting.
I will just have to wait until it goes mainstream though before getting to play with it.
I used your previous video on password complexity to build one of my own.
I actually built a password generator which includes the complexity test.
this new way certainly looks easier.😀
Awesome; I’m so proud of you! So glad that video helped you with that project. Thanks so much for watching.
I caught your joke ;)
Are these only available on insider? co pilot says they are available in all versions of xl, and if so when will we get them, still waiting for group by.
As far as I know, it’s just an Insider Preview at the moment.
Um, what? Leila has over 2.6 million followers.
(That's the joke)
@@bcti-bcti Uh oh - I missed the set up (now I'm the joke)!
@@mcegirl4 no worries. 99% of us can only dream of being as good and as popular as Leila.
@@bcti-bcti That's why I love your videos (very Leia-like)!
Leila