AblebitsRegexRemove function

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

For example:

=AblebitsRegexRemove(A1,"(\d{3}-\d{3}-\d{4})") removes a string that matches 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

AblebitsRegexRemove(reference,regular expression)

The AblebitsRegexRemove function syntax has the following arguments:

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

Remarks

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

Please contact us here

Our working hours:
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Central European Time (CET) 08:00 - 23:00
Eastern Time (ET) 2:00 AM – 5:00 PM
Central Time (CT) 1:00 AM – 4:00 PM
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Australian Eastern Daylight Time (AEDT) 6:00 PM – 9:00 AM (next day)
If you want to attach files (e.g. screenshots or log files), it will be possible right after you send this form and we automatically create a support ticket for you.