Рет қаралды 747
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.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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.buymeacoff...
#excel
#googlesheets
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~