REGEXEXTRACT practice

REGEXEXTRACT returns the first part of a text that 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

REGEXEXTRACT(text, regular_expression)

What people get wrong

Put the part you want in parentheses; only the capture group is returned.

Google Sheets exercise that use REGEXEXTRACT

• Pull out the invoice numberLevel 5Pro

Often used together with: VALUE