
Regular expressions
Regular expressions are a programming term that refers to a sequence of characters used to define a search criterion within a given text. Recently, Excel has gained several functions for working with regular expressions, and we can also use them as an argument to the XMATCH function and the XLOOKUP function as an additional search criterion.