Remove Middle Name | Change Email Domain with Regular Expressions - Google Sheets

At first you might think what is a regular expression?? When I first heard this word, I had the same thought...confusion...but then that turned into curiosity and excitement when I learned it could do some pretty cool things. Things that a regular find and replace couldn’t readily do; like remove middle names from a name list. Or change out email domains in less steps.
That’s the power of “regular” expressions in google sheets.
0:00 Intro
0:36 Middle Name Replacement - Find and Replace with Regular Expression
3:06 Email Domain Name Replacement - Find and Replace with Regular Expression
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoffee.com/dough
#excel
#googlesheets
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@wayneedmondson1065]

Cool! Thanks Doug!!

[@DougHExcel]

Thanks for watching Wayne!!

[@RouletteTipsAndTricks]

Good job as always, you inspire me in the creation of spreadsheets for gambling. Keep doing the good job

[@DougHExcel]

Thanks for the kind words!

[@bdbdsbs8196]

How can i add more than 3 sections in footer excel

[@djl8710]

I hear Santa Claus uses regular expressions to sort kids into naughty or nice lists.

[@DougHExcel]

🤣🤣🤣