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.
The most popular seems to be removing one word from a column or a task to remove a list of words from text. The list is already given in this case.
Sometimes you need to remove certain words from range, but there is no list – you only know a certain attribute 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.
This attribute can be the position of words within a cell. There, you would want to:
— delete the first word / the first N words from cells;
— or, the opposite, delete the last word / the last N words.
There are some more complex cases as well. 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.
And last, but not least. Sometimes you just need to remove repetitive words in each cell of the list, leaving only unique ones. All of these cases !SEMTools can handle with incredible speed in a few mouse clicks.
See also:
- 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.