Microsoft has announced the addition of three new functions for Excel, all of which are Regular Expressions (regex) functions. These functions are currently available to Microsoft 365 Insider users.
Previously, Excel users had various ways of using regex on Excel, but now they can directly use the following functions:
REGEXTEST: Validates whether text matches a pattern (returns TRUE or FALSE)
REGEXEXTRACT: Extracts parts of text that match a condition (returns first value, all values, or groups)
REGEXREPLACE: Searches for text that matches a pattern and replaces it as specified
Microsoft mentions that regex will be added as an option in the XLOOKUP and XMATCH functions as match modes in the future. They also caution that all three functions are still in preview status and may be subject to adjustments, so it is not recommended to test them with important data files.
Source: Microsoft
TLDR: Microsoft adds three new Regular Expressions functions to Excel for Microsoft 365 Insider users. These functions allow direct use of regex for text matching, extraction, and replacement. But caution is advised as they are in preview status and may undergo modifications in the future.
Leave a Comment