Hey Microsoft 365 Insiders! Jake Armstrong here from the Excel team. We’re pumped to introduce three new functions that use Regular Expressions (regex) to make text parsing easier: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE. Please note, these are preview functions, so expect changes based on feedback before the final release. Regex helps with string searching and text parsing, allowing you to check, extract, and replace specific patterns. Dive into how each function works, like REGEXTEST checking patterns in text, REGEXEXTRACT pulling out matching substrings, and REGEXREPLACE changing text based on patterns. You can soon use regex with XLOOKUP and XMATCH too. Give these functions a try and share your thoughts with us!
https://insider.microsoft365.com/en-us/blog/new-regular-expression-regex-functions-in-excel