REGEX_MATCHALL

Returns all matches in the specified string found by the supplied regex.

Syntax

=REGEX_MATCHALL(regex, string)

Arguments

Argument	Type	Description
regex	String	The regex to use when looking for matches
string	String	The string to look for matches in

Examples

=REGEX_MATCHALL("(o(\s|r))", "Hello world")→["o ", "or"]