How to Use REGEXEXTRACT in Google Sheets: Simple Guide

Use REGEXEXTRACT(text, regular_expression) in Google Sheets to pull out text that matches a pattern. It returns the first matching part of the text based on the regular expression you provide.

Syntax

The REGEXEXTRACT function has two parts:

• text: The cell or text string you want to search.
• regular_expression: The pattern you want to find inside the text.

The function returns the first part of the text that matches the pattern.

plaintext

REGEXEXTRACT(text, regular_expression)

Example

This example extracts the first word starting with a capital letter from a sentence.

google_sheets

=REGEXEXTRACT("Hello world from Google Sheets", "[A-Z][a-z]+")

Output

Hello

Common Pitfalls

Common mistakes include:

• Using a pattern that matches nothing, which causes an error.
• Not escaping special characters like dots or parentheses.
• Expecting multiple matches; REGEXEXTRACT only returns the first match.

Always test your pattern on sample text to avoid errors.

google_sheets

=REGEXEXTRACT("Price: $100", "$[0-9]+")  <em>Wrong: unescaped $ causes error</em>

=REGEXEXTRACT("Price: $100", "\$[0-9]+")  <em>Right: escaped $ to match literal dollar sign</em>

Output

Error
$100

Quick Reference

Part	Description	Example
text	Text or cell to search	"Hello World" or A1
regular_expression	Pattern to find	"[A-Z][a-z]+"
Returns	First matching text	"Hello" from example

Key Takeaways

REGEXEXTRACT extracts the first matching text based on a pattern from a string.

Always escape special regex characters like $, ., or parentheses.

It returns an error if no match is found, so test your patterns carefully.

Use simple patterns first and build complexity as you get comfortable.

REGEXEXTRACT only returns one match; use other functions for multiple matches.