Thats finally changing, with the introduction of regular expression functions in Excel.
Regular expressions, also known as regex or regexp, are strings used to match patterns in data strings.
it’s possible for you to then remove, replace, or extract the matches as needed.
Microsoft
Microsoft announced three new functions that use regular expressions, available now in the Excel Beta Channel.
Microsoft also plans to add support for regular expressions to ExcelsXLOOKUPandXMATCHfunctions.
Presumably, that will allow searching across entire Excel workbooks for regular expression matches.
Source:Microsoft 365 Insider
