Extract Segmented Strings

The Extract Segmented Strings function is a feature that enables you to selectively extract parts of strings based on specified delimiters within your cells.

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.

• Delimiter: Select a character or string to act as the delimiter. This could be any character like a comma, space, or a specific symbol that separates segments within your text.

• Which Number Delimiter: Specify which occurrence of the delimiter to use as the reference point. For instance, if you choose 1, the function will use the first delimiter as the reference for extraction.

• Extract Direction

  • Front: Extracts all characters that appear before the specified delimiter occurrence.

  • Middle: Extracts the range of characters from the specified delimiter occurrence to the next one.

  • Back: Extracts all characters that follow the specified delimiter occurrence.

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.