How to Rock Regex Functions in Google Sheets
Based on: https://bit.ly/regex-sheets. 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