The AblebitsRegexMatch function searches for text that matches the specified regular expression, and then returns TRUE if match is found and FALSE if not.
For example:
=AblebitsRegexMatch(A1,"(\d{3}-\d{3}-\d{4})") searches for text matching the regular expression (\d{3}-\d{3}-\d{4})") in the A1 cell.
Note. Formulas created with this function will work only on machines with installed Ultimate Suite for Excel. If the workbook is opened on another computer where Ultimate Suite is not installed, the result will be lost.
Syntax
AblebitsRegexMatch(reference,regular expression)
The AblebitsRegexMatch function syntax has the following arguments:
-
reference
Required. The cell reference that contains data to search for match with the regular expression.
-
regular expression
Required. The regular expression.
-
The AblebitsRegexMatch function is used by the Regex Tools add-in when you select Match option and the check the Insert result as formula box before pasting the result.
To learn more about the Regex Tools add-in and other custom Ablebits Regex functions, please see: