REGEXEXTRACT

Extracts text that matches the pattern.

Syntax

REGEXEXTRACT(text, regular_expression, [return_mode], [case_sensitivity])

text: The text given as input.

regular_expression: The first part of text that matches this expression will be returned.

return_mode: A number that specifies what strings you want to extract. By default, return mode is 0. The possible values are:

0: Return the first string that matches the pattern

1: Return all strings that match the pattern as an array

2: Return capturing groups from the first match as an array

Note: Capturing groups are parts of a regex pattern surrounded by parentheses "(...)". They allow you to return separate parts of a single match individually.

case_sensitivity: Determines whether the match is case-sensitive. By default, the match is case-sensitive. Enter one of the following:

0: Case sensitive
1: Case insensitive

Examples

Formula	Result
=REGEXEXTRACT("Hello 123"; "[0-9]+")	123
=REGEXEXTRACT(A3; "[0-9]*\.[0-9]+[0-9]+")	46.59
=REGEXEXTRACT(A4; "\(([A-Za-z]+)\)")	Text

Get a hands-on experience of the function in the embedded range below.

Possible Errors

Errors	Meaning
#N/A!	The specified delimiter was not found in the given text string. The given instance value is higher than the total occurrences of the delimiter in the text string.
#NAME!	The function name is incorrect or invalid. The given defined name (if any) is invalid. There is a typo in the defined name used in the function. Double quotes are missing for text values in the function. Colon missing in a cell range reference.
#VALUE!	The given argument's data type is incorrect or invalid. The given instance value is 0 or higher the length of the text string.
#REF!	The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.

Similar Functions