# REGEXTEST

## Content

The REGEXTEST function allows you to check whether any part of the supplied text matches a regular expression ("regex"). It returns TRUE if it does, and FALSE if it doesn't.

## Syntax

REGEXTEST(text, pattern, [case\_sensitivity])

## Arguments

| **Argument** | **Description** |
| -------- | ----------- |
| *text* | [Required] The text or the reference to a cell containing the text you want to match against. |
| *pattern* | [Required] The regular expression ("regex") that describes the pattern of text you want to match. |
| *case\_sensitivity* | [Optional] Determines whether the match is case-sensitive.<br>**0** – Case sensitive(default)<br>**1** – Case insensitive |

## Remarks

Return: `TRUE` or `FALSE`. The regex test result.

## Examples

`REGEXTEST("abc","a")` gives the result TRUE
`REGEXTEST("abc","[A-Z]")` gives the result FALSE
`REGEXTEST("abc","[A-Z]", 1)` gives the result TRUE
`REGEXTEST("abc","[0-9]")` gives the result FALSE

## Version Available

This function is available in product version 19.0 or later.