New Regular expression (Regex) functions in Excel

Regular expressions, or ‘regex’, are sequences of characters that define search patterns, commonly used for string searching and text parsing. They are incredibly versatile and are often used to check if a string contains a certain pattern, extract substrings that match the pattern, or replace substrings that match the pattern.

The new regex functions we are introducing are:

  • REGEXTEST: Checks if any part of supplied text matches a regex pattern.
  • REGEXEXTRACT: Extracts one or more parts of supplied text that match a regex pattern.
  • REGEXREPLACE: Searches for a regex pattern within supplied text and replaces it with different text.

Availability

These functions are currently available to Beta Channel users running:

  • Windows: Version 2406 (Build 17715.20000) or later
  • Mac: Version 16.86 (Build 24051422) or later

 

For more information:

New Regular expression (Regex) functions in Excel (microsoft365.com)

 

Microsoft 365 Insider for Windows is available for those with a Microsoft 365 subscription in two levels: Beta Channel and Current Channel (Preview).

Beta Channel

This level is best for those who want to use the latest builds to identify issues and provide feedback about new features still in development, and don’t mind the bit of risk involved in using unsupported builds.

 

 

Current Channel (Preview)

Current Channel (Preview) is best for fans or early adopters who want early access but also want to receive less frequent, more stable updates. Builds come out monthly and are fully supported.

For checking the Eligibility of downloading Microsoft365 Insider builder on device, for choosing an insider level, for installing insider builder please go through the below link:

Join the Microsoft 365 Insider Program

 

For the comparison between Beta channel and Current Channel

Category

Beta Channel

Current Channel (Preview)

Description

Includes features that are still in development.

Includes features that are in their final stages of development, so they're less likely to change.

Recommended use

Might be appropriate for a set of early adopters so that they can provide feedback on features that are under development.

Beta Channel provides access to new features even before they're available in Current Channel (Preview).

Note: Beta Channel isn't supported. It should be used only in test environments and by a small group of select users, such as IT staff or application developers.

Your organization gets updates to Microsoft 365 Apps from Current Channel, and you want to preview upcoming features on a subset of devices.

 This preview can help you identify any possible issues for your organization and provide feedback to us before the new features are released to users on Current Channel.

Release frequency

Weekly

A few times per month.

 There isn’t a set release schedule for Current Channel (Preview). In general, a new version of Current Channel (Preview) with new features is released at least a week or more before that new version is released to Current Channel.

Feature and nonsecurity updates

Weekly

 Note: Not all users receive new features at the same time.

A few times per month.

 There Might be several releases of Current Channel (Preview) before that version is released to Current Channel.

Security updates
 (if needed)

Monthly

Monthly

Support duration

Not supported

 Should be used only in test environments.

Supported until the next version is released.

 For example, Version 2204 is supported until Version 2205 is released.

For more information: Compare Microsoft 365 Insider channels - Microsoft 365 Insider | Microsoft Learn