REGEXMATCH and REGEXEXTRACT in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the REGEXMATCH function do in Google Sheets?

REGEXMATCH checks if a text matches a pattern you give it. It returns TRUE if it matches, and FALSE if it does not.

beginner

How does REGEXEXTRACT work in Google Sheets?

REGEXEXTRACT finds and returns the part of the text that matches the pattern you give. If nothing matches, it returns an error.

beginner

Example: What will =REGEXMATCH("apple pie", "apple") return?

This will return TRUE because the text "apple pie" contains the word "apple" which matches the pattern.

beginner

Example: What will =REGEXEXTRACT("Order #12345", "\d+") return?

This extracts the first group of digits from the text. It will return 12345.

beginner

What happens if REGEXEXTRACT finds no match?

If no match is found, REGEXEXTRACT returns an #N/A error because it cannot extract anything.

What does REGEXMATCH return when the pattern matches the text?

A FALSE

B The matching text

C TRUE

D An error

REGEXMATCH returns TRUE if the pattern matches the text.

Which function extracts the matching part of text based on a pattern?

A REGEXEXTRACT

B SEARCH

C REGEXREPLACE

D REGEXMATCH

REGEXEXTRACT returns the part of the text that matches the pattern.

What will =REGEXMATCH("hello world", "world") return?

A FALSE

B TRUE

C world

D #N/A error

The text contains "world", so REGEXMATCH returns TRUE.

What does \d+ mean in a regex pattern?

A One or more digits

B One or more letters

C Any character

D Whitespace

\d+ means one or more digits (numbers).

If REGEXEXTRACT does not find a match, what happens?

A Returns empty string

B Returns FALSE

C Returns TRUE

D Returns #N/A error

REGEXEXTRACT returns a #N/A error if no match is found.

Explain how you would use REGEXMATCH to check if a cell contains the word "cat".

Think about how to write the pattern and what the function returns.

Describe a situation where REGEXEXTRACT would be useful and how it works.

Consider extracting numbers or words from a longer text.