Extract by Regex

The Extract by Regex function is a feature that allows you to use regular expressions (regex) for advanced text extraction.

See it in Action

Requirements

Data

• Target Data

  • Data Range: Identify the cells range where you want to apply the function.

  • Columns Included: Check this option if your selected range includes the first row as column headers. This ensures that the first row is recognized as column names and excluded from the processing.

• Words to extract

  • Input Texts: Enter the specific words or phrases you wish to extract from the selected data range. This can be a single word or multiple words separated by a delimiter.

  • Case Insensitive?: Select this option if you want the search to be case-insensitive, making the function ignore case differences when identifying matches.

• Delimiter: Choose a delimiter (like a comma or space) to separate multiple extracted items in the output.

Fill empty cells with

• Keep Empty: Leave cells that are empty as is, without adding any text.

• Forward Fill: Copy the value from the nearest non-empty cell above into empty cells before adding the specified letters or text.

• Backward Fill: Copy the value from the nearest non-empty cell below into empty cells before adding the specified letters or text.

• -: Fill empty cells with a letter "-".

• 0: Fill empty cells with a letter "0".

• Custom: Allows for a custom value or text to be inserted into empty cells prior to adding the specified letters.

Result Destination

Specify the starting cell where the results will be placed.