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.
In !SEMTools these are in DELETE → Words → Full words: 1 word, Input range… for your own list (anywhere, only if first or only if last), and Markers, ready lists of rent, sell and review words.
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.
Menu: DELETE → Words → By substring… (Containing, Beginning with, Ending with) and DELETE → Words → By RegExp pattern.
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.
Menu: DELETE → Words → By substring… → Containing…, where Latin characters and Numbers sit next to the patterns.
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.
Menu: DELETE → Words → By position…, then First or Last: 1, 2, 3 or 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.
Menu: DELETE → Words, the submenu for repeating words inside a cell.
See also:
- Sentence case in Excel: capitalize first letter in all cells
- Remove Punctuation in Excel
- Delete cells by content in Excel
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;