Remove rows by substrings in Excel

With Ultimate Suite for Excel

Apply the Remove Rows by Substrings feature from Substring Tools to erase all the rows with certain text values at one go. Specify what substrings should be found and deleted along with the rows that contain them and get the desired result shortly.

Before you start

Give attention to the points below:

  • Only one column is processed at a time.
  • Place the substrings to be looked for in one and the same column in an individual cell each.

How to remove rows by substrings

Start the Remove Rows by Substrings tool by clicking the Substring Tools icon on the Ablebits Data tab and picking Remove Rows by Substrings:
Start the Remove Rows by Substrings tool.
You will see the tool window:
Adjust the Remove Rows by Substrings settings.

  1. Select a column containing the data to be processed—the Source column.
  2. Using the icons on the right side of the Source column box, you can select your current table column or any other column you need.
  3. Select a column containing the substrings to be looked for—the Substrings range.
  4. If the search for substrings should be case-sensitive, pick the Case-sensitive option.
  5. Make sure that there is a tick next to the Back up this worksheet option if you prefer to save the original data.

Take a look at an example:
Here is the example.
After you click the Remove button, the tool will process your data and inform you about the result:
The rows are removed.

To learn about the other Substring Tools features, visit the following help pages: