Assigning texts to contained words

An Excel file that teaches how to perform Assigning Texts to Words That Contain operation.

Excel Solution: Assigning Texts to Contained Words

The text content is scanned using a formula. When a match is found, the category value is returned. Multiple words are combined using the OR condition. Incorrect matches are listed in the warning column. An example of usage is shown in the table.

Hope it is useful.