REGEXTEST
Determines whether any part of text matches the pattern.
TextModern Excel FunctionsText Processing
What it does
Returns TRUE if pattern is found in text.
Syntax
REGEXTEST(text, pattern, [case_sensitivity])
Arguments
text(text) — Source text.pattern(text) — Regex pattern.
Examples
Check Digits
Does it contain numbers?
FORMULA
=REGEXTEST("abc", "\d")RESULT
false
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | abc |