Is it possible to include more than two criteria in the Search and Replace tool in Excel? I would like to select all cells in a sheet where part of the cell value matches 3 specific texts, but avoid doing it 3 times. The Advanced Filter option works for 2 conditions, but I need 3.

CodePudding user response：

Not sure what you mean - you can certainly have a setup like this in advanced filter:

and filter like this:

which will include the first three rows.