To delete unwanted text fragments all over any of your columns with ease, apply the Remove Substrings feature in Substring Tools. Just make a list of the substrings you need to erase, and the add-in will do the job.
Take notice of the following:
To run the Remove Substrings tool, click the Substring Tools icon on the Ablebits Data tab and select Remove Substrings:
The tool pane appears:
Here is the example:
After you click the Remove button, your data is processed. The results are placed on the right of the source column and a summary message appears:
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!