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 ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://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
https://www.buymeacoffee.com/dough

#excel
#googlesheets
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~