Microsoft Excel Tutorial: Learning the Building Blocks for RegEx in Excel
Learn the basic building blocks of RegEx in Excel.

To download the RegEx Cheat Sheet and workbook from today: https://www.mrexcel.com/youtube/fbHQgDM0P1E/

Welcome back to MrExcel’s YouTube channel! In this video, we’ll dive into the building blocks for mastering Regular Expressions (RegEx) and their integration in Excel. If you find this video helpful, don’t forget to click the Like button below – it helps us reach more viewers. We’ve got over 2,500 videos on various Excel topics, so there’s plenty to explore!

Our focus today is on RegEx, specifically the new functions in Excel: RegExTest, RegExExtract, and RegExReplace. I’ll break down these functions step-by-step, making it easy for you to grasp the concepts. And remember, you can always visit our site at mrx.cl/gpt to type in any questions you have. You’ll get a summary of relevant videos where I’ve covered those topics extensively.

This video is designed to get you comfortable with RegEx, even if you’re a complete beginner. I’ll walk you through examples like matching specific sequences of letters, using wildcards, and understanding special characters. By the end, you’ll have a solid foundation in using RegEx within Excel. Don’t forget to download the tip card below, summarizing everything we discuss today.

One of the key points we’ll cover is how different characters and sequences can be matched using RegEx patterns. For instance, how to specify that a cell starts with a certain string or contains a specific character set. These examples will demonstrate the versatility and power of RegEx in data manipulation and search tasks.

Lastly, I’ll share some advanced techniques, like using repetition operators and handling white spaces, including tricky non-breaking spaces. This will prepare you to tackle more complex text processing tasks in Excel. As always, if you have any questions, leave them in the comments, and I’ll be sure to address them.

Thanks for watching! If you enjoyed this video, please Like, Subscribe, and Ring the Bell to stay updated with all my latest Excel tips and tutorials. See you next time for another exciting video from MrExcel!

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(00:00) Intro to RegEx Building Blocks
(00:10) MrExcel GPT to answer your Excel questions
(00:30) Download RegEx Tip Card
(00:41) Building Blocks of RegEx
(01:13) RegEx Basics
(02:15) RegEx Starts With or Ends With
(02:35) RegEx Two Meanings of Tilde
(03:52) RegEx Wildcards
(05:48) More RegEx Wildcards
(08:05) Repetition in RegEx
(12:07) Whitespace in RegEx
(14:02) Converting Non-Breaking Space to Space Using RegEx
(16:24) Returning part of a match in REGEXEXTRACT
(18:50) Transposing multiple spilled results
(19:30) Download the Workbook
(19:46) Like, Subscribe & Ring the Bell

This video answers these common search terms:
Excel RegEx tutorial
How to use Regular Expressions in Excel
Excel RegEx functions explained
RegExTest Excel function guide
Excel RegExExtract examples
Advanced Excel RegEx techniques
RegExReplace in Excel tutorial
Learning RegEx for Excel beginners
Excel text manipulation with RegEx
MrExcel RegEx basics