The !SEMTools add-in can remove words from text in many ways. Below are the cases with links to more detailed descriptions of the corresponding functionality.
Remove words by exact match
The most popular seems to be removing one word from a column or a task to remove multiple words from text. The list of words is already given in this case.
Remove words by substring or RegEx match
These are more complex cases. For example, the task of removing words that end with a letter or sequence of letters, or remove words that begin with some characters.
Regular sequences may not be enough either, in such cases removing words using regular expressions will help.
Remove words on condition
Sometimes you need to remove certain words from range, but there is no list – you only know a certain criteria that characterizes these words. This attribute can be the inclusion of certain characters (english letters, numbers) in the words. Here you would like to:
— remove words containing Latin characters;
— remove words containing numbers / consisting only of numbers.
Remove words by position
Word position within a cell may also be a criteria for deletion. There, you might need to:
— delete the first word / the first N words from cells;
— or, the opposite, delete the last word / the last N words.
Delete repeated words
And last, but not least. Sometimes you just need to remove repetitive words in each cell, leaving only unique ones.
See also:
Extract words from text in Excel
How to replace multiple words in bulk
How to remove unneeded characters in Excel;
How to delete cells by condition in Excel;
How to remove unnecessary columns and rows by multiple conditions;
How to remove formulas from cells and leave only values.
This post is also available in RU.