AblebitsRegexExtract function

The AblebitsRegexExtract function searches for a match with the specified regular expression in a cell, and returns it if finds.

For example:

=AblebitsRegexExtract(A1,"(\d{3}-\d{3}-\d{4})") returns a match with the regular expression (\d{3}-\d{3}-\d{4}) in the A1 cell.

Tip. For the regular expression language details, please refer to the guide: Regular Expression Language - Quick Reference
Note. Formulas created with this function will work only on machines with installed Ultimate Suite for Excel. If the workbook is opened on another computer where Ultimate Suite is not installed, the result will be lost.
Tip. You can find the complete list of custom functions on the Ablebits functions for Excel page.

Syntax

AblebitsRegexExtract(reference,regular expression)

The AblebitsRegexExtract function syntax has the following arguments:

  • reference
    Required. The cell reference that contains data to search for match with the regular expression.
  • regular expression
    Required. The regular expression.

Remarks

  • The AblebitsRegexExtract function is used by the Regex Tools add-in when you select Extract option and the check the Insert result as formula box before pasting the result.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.