Test text with REGEXMATCH
Step 1 of 3
The REGEX functions search with a pattern instead of exact text. \d means any digit, and + means one or more of it.
Click Continue when you're ready.
Already know it? Type the formula straight into B2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Note | Has a number | ||||
| 2 | Order 1001 shipped | |||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
REGEXMATCH looks for the pattern anywhere in the text and gives TRUE if it finds it. \d+ matches 1001, so the answer is TRUE. A note with no digits, such as "Waiting for stock", would give FALSE.
Common mistake: Forgetting the backslash. d is the letter d; \d is any digit.
The answer
- B2
=REGEXMATCH(1A2,2"\d+")
In plain words: TRUE when 1the note in A2 contains 2at least one digit.
It checks whether a text matches a regular expression and gives TRUE or FALSE. =REGEXMATCH(A2,"\d+") is TRUE when A2 contains at least one digit. It needs text: a number in the cell gives an error.
+10 points