Microsoft Excel - New REGEX Functions are Amazing!

preview_player
Показать описание
Learn about the new set of REGEX functions being released into Excel and integrated into existing functions.

File Download Link:

Leila's REGEX video on her YouTube channel (XelPlus):

Original Password Checking project video:

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
  1. BCTI
  2. ChatGPT
  3. Excel
  4. REGEX
  5. REGEXEXTRACT
  6. REGEXREPLACE
Рекомендации по теме
Introducing REGEX Excel 0:19:22

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

Excel Just Got 0:05:55

Excel Just Got NEW REGEX Functions You Need to Try!

Easy Data Cleaning 0:09:18

Easy Data Cleaning with NEW Regex Functions in Excel

Microsoft Excel - 0:05:55

Microsoft Excel - New REGEX Functions are Amazing!

Introducing the new 0:03:22

Introducing the new REGEX function set in Excel

Excel RegEx Example 0:00:30

Excel RegEx Example

Enable use of 0:00:44

Enable use of regular expressions (RegEx) in Excel

*NEW* Regex Extract 0:00:36

*NEW* Regex Extract Function in Excel 🎉 #excel #exceltips #corporate #accounting #finance

Breaking News! We 0:10:51

Breaking News! We FINALLY get the New Excel functions we've been Wanting!

New REGEX Functions 0:08:02

New REGEX Functions in Excel

Brand New Excel 0:10:18

Brand New Excel REGEX Functions | Clean your messed up data

NEW REGEX functions in 0:00:20

NEW REGEX functions in Excel | Amazing functions for data cleaning!

The Shocking Mistake 0:00:33

The Shocking Mistake You're Making with Excel REGEX REPLACE in 2024

New Excel Functions 0:09:10

New Excel Functions - Regular Expression 'Regex'

Use Regular Expressions 0:04:56

Use Regular Expressions in Excel in 2024

Excel's Secret Weapon: 0:00:36

Excel's Secret Weapon: Extract Data Like a Pro with Regex!

Get started with 0:23:15

Get started with Regex (in Excel)

NEW REGEX functions in 0:15:12

NEW REGEX functions in Excel | Amazing functions for data cleaning!

10 Excel Formulas 0:18:04

10 Excel Formulas That Will Set You Apart (+Cheat Sheet)

Regexreplace formula in 0:00:26

Regexreplace formula in Excel#Techglobal

*NEW* Regex Replace 0:00:35

*NEW* Regex Replace Function in Excel‼️ #excel #exceltips #accounting #corporate #finance

REGEX Functions in 0:06:18

REGEX Functions in Excel

How to Use 0:00:33

How to Use REGEXREPLACE in Excel for Text Editing (2024)

Regular Expression Match 0:20:00

Regular Expression Match Formula in Excel (No VBA) - Regex System Part 1

Комментарии
Автор

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.

FsoOmar
Автор

Yes Sir. We are following her and many others. They are all very helpful. I have learnt so much from all of them.

sridharramadurai
Автор

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.😀

DingusBatus
Автор

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.

williamarthur
Автор

Um, what? Leila has over 2.6 million followers.

mcegirl