Get the latest tech news
Regular expression functions in Excel
Check out three new functions that use Regular Expressions to help parse text more easily: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE!
I’m excited to announce the availability of three new functions that use Regular Expressions to help parse text more easily: REGEXTEST, REGEXEXTRACT, and REGEXREPLACE. REGEXTEST checks whether the pattern matches any part of the provided text, always returning TRUE or FALSE. When writing regex patterns, you can use symbols called ‘tokens’ that match with a variety of characters.
Or read this on Hacker News