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.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Excel

Excel

Photo of functions

functions

Photo of regex

regex

Related news:

News photo

Google Sheets’ new formatting feature has Excel switchers excited

News photo

Uni staff fall back on Excel to work around mis-coded transactions in Oracle system

News photo

Amazon CodeWhisperer is now called Q Developer and is expanding its functions