FUNCTION CATALOGUE / TEXT
REGEXTEST Excel function
Tests text against a regular expression in supported Microsoft 365 versions.
Correct sentence to use
Check whether [text] matches the pattern [regex].
Modify this query in PlainFormula →Example formula
=REGEXTEST(A2,"^[A-Z]{2}[0-9]{4}$")
Tests whether text matches a regex where supported.
Syntax
REGEXTEST(text, pattern, [case_sensitivity])
Argument signature: text, pattern, [case_sensitivity]
Availability note
Microsoft 365 builds that include this function; check update channel and platform.