Regular expressions in Excel

Regular expressions in Excel are made easy with the pwrREGEXMATCH function.

As a demonstration of the function, the example file pictured below is set up to evaluate a regular expression entered in cell D2 against text entered in cell D4. The result is contained in cell D8.

The formula used in Excel (cell D8) is the following:

=pwrREGEXMATCH(D4, D2)

That’s it. Download the example worksheet (link below) or just create one on your own. Using this, you can easily try out different regular expressions against some target text to massage into the perfect regex for your need.

Download the sample workbook here.

Here are some related posts:

TEXTJOIN, SWITCH, IFS, MAXIFS, MINIFS, CONCAT Available for Excel 2013, 2010, 2007 Excel WEBSERVICE Function, plus ENCODEURL and FILTERXML Make a Useful Trio of Web Functions How to get the formula of a cell in Excel How to use Excel to test a list of URLs or links to see if any are broken Add Excel 2013 Functions to Excel 2010