REGEXMATCH practice

REGEXMATCH returns TRUE when a text matches a regular expression, in Google Sheets. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

REGEXMATCH(text, regular_expression)

What people get wrong

Anchor the pattern with ^ and $ to validate a whole value such as an order ID.

Google Sheets exercise that use REGEXMATCH

• Valid order IDsLevel 5Pro

Often used together with: ARRAYFORMULA, IF, SUM