How to Rock Regex Functions in Google Sheets

Based on: bit.ly/regex-s.... Are you tired of manually editing your spreadsheets to extract or replace specific text patterns? Then it's time to learn about using regular expressions-aka regex-in Google Sheets! In this video tutorial, we'll take a deep dive into how to use the REGEXMATCH(), REGEXEXTRACT(), and REGEXREPLACE() functions in Google Sheets with real-world marketing examples.
You can also click/tap a minute mark to skip to that section of the video:
00:09 - Using REGEXMATCH() to classify URLs by subdomain
11:04 - Using REGEXEXTRACT() to extract the subdomain
15:29 - Using our new contrived columns in a pivot table and slicer
18:54 - Using REGEXMATCH() to classify keywords as brand or generic
25:12 - Using REGEXREPLACE to switch first and last name and ditch the comma
28:30 - Using REGEXREPLACE to change the formatting of phone numbers

[@dystar112]

Hey - it's been a long time since an Annielytics notification has popped up on my phone 💥

[@imac_]

I just watched your video of 2015 of CSS styles, Its been 8 years and it passed so fast !! Feels like Nostalgic. I grew up watching American cartoons and movies and songs. Love you America ❤❤ from India

[@MichaelBrown-lw9kz]

Welcome back Annie

[@HumanimalChannel]

Hi Annie
I hope you're holding up, you're not forgotten, but are deeply loved.

[@dystar112]

It'd Mother's Day here in Australia so I'm saying it now Happy Mother's Day everyone 💖✨️

[@Paula-po9kx]

Thank you Annie. Hope everything is going good for you, we sure miss you but we understand.

[@222radar]

This is so interesting!

[@222radar]

I'm currently challenged with asset mgmt and learning about DAM vs SAN - I'm an old-school beginner but learning to open my mind to this work

[@222radar]

And thank you, Cool Cat.

[@mherrera1930]

I don't have a clue what I would need this info for but I would like to know what I need this info for......well wishes to you Anne.happy days to you.

[@nataliecassidy4298]

Hi Annie, wanted to check in with you to see how you are doing, I hope you are doing well and are getting through this OK. My love to you and your family 👪. GOD BLESS YOU ALL. From AKRON, OHIO ❤❤❤😊😊😊

[@Annielytics]

I'm so ready for justice to be meted out.

[@ahoymidia2007]

come back !

[@Annielytics]

I’m back. Just posted my first vid yesterday, with many more to come.