REGEX_MATCHALL

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

Syntax

=REGEX_MATCHALL(regex, string)

Arguments

ArgumentTypeDescription
regexStringThe regex to use when looking for matches
stringStringThe string to look for matches in

Examples

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