How can I search using the "text contains" filter option in Google Sheets for multiple individual strings of text?
Currently I can search individually for "amazon"
or "AMZ"
but I would like to search for both "amazon"
and "AMZ"
.
What is the syntax to do this? I've tried a couple of variations but can't get it to work.