Excel: How to Sort or filter text by specific word or words?

Question

Order text by finding the word elephant

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&dog in the cell with Tower&elephant&dog

Is that possible and how? Thank you very much

Solution

Fast - Max 2 Filter Criteria

You just need to apply a custom filter, and then choose contains. To do this, with no filter applied yet, click top left corner right click it and choose Filter | Filter by Selected Cells Value.

You can add multiple entries using the OR option for multiple words:

Contains | dog OR Contains | cat

Greater than 2 Filter Critiera, use Advanced:

1. Set up your criteria range. The header must be named exactly like the column where Excel should apply your filter to (data table in example)

2. Select your whole table (A1:A11 in example)

3. Go to: Menu Bar » Data » Filter » Advanced

4. Select your whole criteria range including the header under Criteria range (C1:C4 in example)

Comments

[Abdirizak Obsiye]

Thank you for that. What if I want more than one word e.g. dog and cat and elephant. So it'll filter by that criteria

[Abdirizak Obsiye]

Actually, sadly this doens't help. I think i'm doing it wrong.

[Admin]

I don't know what has to do with sorting but if you're happy, I can consider the matter closed.