Regular Expressions for Google Sheets | Spreadsheets for Automation in Motion Design

Gain a basic understanding of regular expressions and how you can implement to wrangle your data for automation! 00:00 - overview & definition 01:14 - Regex basics 04:33 - Debugging your expressions 09:48 - Using Regex in Google Sheets 10:40 - removing numbered formatting 12:55 - extracting two hex codes from a single cell 14:50 - extracting names from hyperlinks Regex resources: Practice data: Interactive tutorial: Debugger: ————————————— Website: Instagram: LinkedIn: Resources: Expressions library: Expressions reference: TAGS