Home › Functions › Text › =REGEXTEST()
Text Excel 365 ◉ 26 views

=REGEXTEST()

REGEXTEST Function

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for Mac
=REGEXTEST(text, pattern, [case_sensitivity])
Hover argument names in the table for details.
Output typeLogical
Popularity30 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =REGEXTEST() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download REGEXTEST.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
text Text Required The text or the reference to a cell containing the text you want to match against.
pattern Text Required The regular expression ("regex") that describes the pattern of text you want to match.
case_sensitivity Number Required Determines whether the match is case-sensitive. By default, the match is case-sensitive. Enter one of the following:0: Case sensitive1: Case insensitive

▣ Examples

▦ Data
CellValue
A2 alfalfa
A3 (378) 555-4195
A4 +1(878) 555-8622
A5 alfalfa
A6 (378) 555-4195
A7 +1(878) 555-8622
Does it contain the letter 'a'? =REGEXTEST(A2,"a")
Does it contain any lower case letters? =REGEXTEST(A2,"[a-z]")
Does it contain any upper case letters? =REGEXTEST(A2,"[A-Z]")
Does it contain any vowels? =REGEXTEST(A2,"[aeiou]")
Does it contain any number digits? =REGEXTEST(A2,"[0-9]")
Example 6 =REGEXTEST(A2,"^\([0-9]{3}\) [0-9]{3}-[0-9]{4}$")

⇄ Related Functions

=FILTER() How to use the FILTER function in Excel to filter a range of data based on criteria you define. =IF() How to use the IF function in Excel to make logical comparisons between data values. =EXACT() Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document. =REGEXEXTRACT() This article shows you how REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression. =REGEXREPLACE() REGEXREPLACE Function =SEARCH() The SEARCH function locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. For example, to find the position of the letter "n" in the word "printer", you can use the following function: =SEARCH("n","printer") This function returns 4 because "n" is the fourth character in the word "printer." You can also search for words within other words. For example, the function =SEARCH("base","database") returns 5, because the word "base" begins at the fifth character of the word "database". You can use the SEARCH to determine the location of a character or text string within another text string, and then use the MID to return the text, or use the REPLACE to change the text. These functions are demonstrated in Example 1 in this article.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.