REGEX Functions in Excel

preview_player
Показать описание
This video provides an intro to the following regex (regular expressions) Excel functions:
- REGEXTEST
- REGEXEXTRACT
- REGEXREPLACE
NOTE: these functions are not available in all Excel versions.

Chapters in this video:
00:00 - Introduction
00:18 - Exercise 1
01:57 - Exercise 2
04:50 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

  1. Excel University
  2. combine data in excel
  3. microsoft excel
  4. advanced excel
  5. power automate desktop
  6. power automate
Рекомендации по теме
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

REGEX Functions in 0:06:18

REGEX Functions in Excel

💪 New Excel 0:53:34

💪 New Excel REGEX Functions are INSANELY Powerful (Proof Inside)

XLOOKUP with Regex 0:08:17

XLOOKUP with Regex in Excel

Excel Adds Support 0:03:28

Excel Adds Support For RegEx In XLOOKUP And XMATCH - Episode 2647

NEW REGEX functions in 0:00:20

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

STOP Using Wrong 0:01:07

STOP Using Wrong Regex Functions in Excel!

Introducing the new 0:03:22

Introducing the new REGEX function set in Excel

Easy Data Cleaning 0:02:36

Easy Data Cleaning with NEW Regex Functions in Excel - Excel Tips and Tricks

Microsoft Excel - 0:05:55

Microsoft Excel - New REGEX Functions are Amazing!

New Excel Functions 0:09:10

New Excel Functions - Regular Expression 'Regex'

How to use 0:15:49

How to use Regular Expressions with Excel VBA (Part 1)

The Shocking Mistake 0:00:33

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

Introducing REGEX Excel 0:02:24

Introducing REGEX Excel Functions - Extract & Real Life Examples & Practical Difficulties &a...

Excel RegEx Example 0:00:30

Excel RegEx Example

Get started with 0:23:15

Get started with Regex (in Excel)

regex excel function 0:04:02

regex excel function

NEW REGEX functions in 0:15:12

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

Change the Way 0:18:33

Change the Way You Use Excel With These NATIVE Regular Expressions (RegEx) Functions!

Regular Expression Match 0:20:00

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

Brand New Excel 0:10:18

Brand New Excel REGEX Functions | Clean your messed up data

New Regex Modes 0:00:43

New Regex Modes for XLOOKUP and XMATCH in Excel 365 #shorts

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

Great job Jeff I have started to understand it with this video

KleopatraFornalik
Автор

Jeff, Thank for the video; but I think I'll stay with flash-fill as it seem less problematic. best regards from chicago

BigD
Автор

Thanks for your calendar build vid! Having prob showing multiple events per day in nicely lined up single lines per event. Would regex be good to delete the commas? I'm trying courier font to get events to not wrap... Is there a better way? Thank you!

WavzonRox
Автор

Love your videos - maybe I missed it but I don't think you mentioned that this is still in beta testing phase and not available to most of us who are not microsoft insiders - or is it just me?

peterleigh