How to Filter Cells that Contain Multiple Words in Excel

To filter cells that contain multiple words in Excel, you can use the "Filter" feature along with a custom filter formula. Here's a step-by-step guide on how to do this:

1. First, make sure that your data has headers (titles for each column). If not, add headers to your data.
2. Click anywhere in your dataset to make it the active cell.
3. Go to the "Data" tab on the Ribbon.
4. Click on the "Filter" button. This will add drop-down arrows to the headers of your dataset.
5. Click on the drop-down arrow of the column you want to filter by multiple words.
6. In the drop-down menu, click on "Text Filters" and then select "Custom Filter."
7. In the "Custom AutoFilter" dialog box, you can now set up your filter criteria.

Example

Let's say you have a dataset with a column called "Description" and you want to filter rows that contain the words "apple" and "banana". Follow these steps:

1. Click on the drop-down arrow of the "Description" column.
2. Click on "Text Filters" and then "Custom Filter."
3. In the "Custom AutoFilter" dialog box, select "contains" in the first drop-down menu.
4. Type "apple" in the text box next to the first drop-down menu.
5. In the middle of the dialog box, select "AND" to make sure both conditions must be met.
6. In the second set of drop-down menus, select "contains" and type "banana" in the text box next to it.
7. Click "OK".

Now, your dataset will be filtered to show only rows where the "Description" column contains both "apple" and "banana". If you want to clear the filter, simply click on the "Filter" button in the "Data" tab again or click on the drop-down arrow in the filtered column and select "Clear Filter from [Column Name]".