Excel & Sheets practice: Google Sheets Regular Expressions
Chapter 22 · 2 questions · included in full access
Question 1 · medium
Flag Gmail leads
Solve it in your browserReturn TRUE when the Email is a gmail.com address (any capitalisation), otherwise FALSE. Start in H2, fill to H9.
Question 2 · medium
Invoice year with a capture group
Solve it in your browserUsing REGEXEXTRACT with a capture group, pull the four-digit year out of each Invoice. Start in H2, fill to H9.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing