Excel: How to Sort or filter text by specific word or words?
<p><a href="https://i.stack.imgur.com/HO1In.png" rel="nofollow noreferrer">Order text by finding the word elephant</a></p>

<p>Is it possible to order/sort/filter a column based on a specific word even if the word is in a sentence in the cell. For example in my image I'd like to order the column by the word elephant. So the cell with elephant will be at the top. Or better yet , order/filter/sort the column by two word in the same sentence e.g. elephant&amp;dog in the cell with Tower&amp;elephant&amp;dog</p>

<p>Is that possible and how? Thank you very much</p>