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.
Give attention to the points below:
Start the Remove Rows by Substrings tool by clicking the Substring Tools icon on the Ablebits Data tab and picking Remove Rows by Substrings:
You will see the tool pane:
Take a look at an example:
After you click the Remove button, the tool will process your data and inform you about the result:
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!