As promised, Excel 365’s Regular Expression support has been extended to include both Xlookup() and XMatch() functions. Regex adds a huge amount of power to matching results from a table. Back in July, Excel 365 added three Regular Expression (regex) functions, RegexTEST(), RegexEXTRACT() and RegexREPLACE(). At the time Microsoft promised
Now that Excel is getting proper Regular Expressions (Regex) here’s some resources to get you started. The upcoming Excel functions RegexTest(), RegexExtract() and RegexReplace() use a common type of regex (PCRE2) rather than some special Microsoft version. That’s important because each regex version has its own options and peculiarities. Using
Excel 365 is getting new functions that bring the power of Regular Expressions (RegEx) into spreadsheets. It’s HUGE news and a big step forward for Excel. We’ve spent some time trying out the new functions and we’re genuinely excited by the possibilities. These three Regular Expression (Regex) functions are now
