Welcome to Portal

?Unknown\pull-down

Welcome to Zoho Cares

Bienvenido a Soporte de Zoho

Search our knowledge base, ask the community or submit a request.

REGEXEXTRACT

Extracts text that matches the pattern. 
Syntax 

REGEXEXTRACT(text, regular_expression)

text: The text given as input.

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


 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 


Helpful?00
Updated: 33 minutes ago
Share :