REGEXMATCH and REGEXEXTRACT in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if cell A1 contains the word "cat".

Google Sheets

=REGEXMATCH(A1, [1])

Drag options to blanks, or click blank then click option'

A"cat"

B"dog"

C"bird"

D"fish"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put quotes around the pattern.

Using the wrong word in the pattern.

The formula =REGEXMATCH(A1, "cat") returns TRUE if the text in A1 contains the word "cat".

2fill in blank

medium

Complete the formula to extract the first number from cell B2.

Google Sheets

=REGEXEXTRACT(B2, [1])

Drag options to blanks, or click blank then click option'

A"[a-z]+"

B"\\d+"

C"\\s+"

D"[A-Z]+"

Attempts:

3 left

💡 Hint

Common Mistakes

Using letters instead of digits in the pattern.

Not escaping the backslash properly.

The pattern "\\d+" matches one or more digits, so =REGEXEXTRACT(B2, "\\d+") extracts the first number from the text.

3fill in blank

hard

Fix the error in the formula to extract the domain from an email in cell C3.

Google Sheets

=REGEXEXTRACT(C3, [1])

Drag options to blanks, or click blank then click option'

A"@(.+)"

B"@(.+)$"

C"@(.+)\\..+"

D"@(.+\\..+)"

Attempts:

3 left

💡 Hint

Common Mistakes

Not including the dot in the domain pattern.

Using end-of-string anchor incorrectly.

The pattern "@(.+\\..+)" correctly extracts the domain part after the '@' including the dot and domain extension.

4fill in blank

hard

Fill both blanks to create a formula that checks if cell D4 contains a 3-letter word starting with 'a'.

Google Sheets

=REGEXMATCH(D4, [1] & [2])

Drag options to blanks, or click blank then click option'

A"\\ba"

B"\\w"

C"\\b"

D"\\w{2}\\b"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using word boundary \\b.

Using wrong quantifier for length.

The pattern "\\ba" means word boundary followed by 'a', and "\\w{2}\\b" means two word characters followed by word boundary. Together they form \\ba\\w{2}\\b which checks for a 3-letter word starting with 'a'.

5fill in blank

hard

Fill all three blanks to extract the area code (3 digits) from a phone number in cell E5 formatted like [phone].

Google Sheets

=REGEXEXTRACT(E5, [1] & [2] & [3])

Drag options to blanks, or click blank then click option'

A"\\("

B"(\\d{3})"

C"\\)"

D"\\s"

Attempts:

3 left

💡 Hint

Common Mistakes

Not escaping parentheses.

Using wrong number of digits in the pattern.

The pattern "\\(" matches the opening parenthesis, "(\\d{3})" matches and captures exactly 3 digits (the area code), and "\\)" matches the closing parenthesis. Together they extract the area code from the phone number.