New
#1
How to search multiple words in excel?
In excel 2021 there are many cells and I want to search for the cell that contains multiple keywords in no particular order, how to search?
For example the excel sheet has A1 to A6 total 6 cells contents below.
I want find the cell that contains these 2 words "reusable" and "plastic", the result shown to me will be A6 cell.
I want find the cell that contains these 3 words "water" and "wood" and "leather", the result shown to me will be A3 cell.
How to search/find in excel 2021?
A1 cell: A water bottle is a container that is used to hold liquids, mainly water, for the purpose of transporting a drink while travelling or while otherwise away from a supply of potable water.
A2 cell: Water bottles are usually made of plastic, glass, metal, or some combination of those substances.
A3 cell: in the past, water bottles were sometimes made of wood, bark, or animal skins such as leather, hide and sheepskin.
A4 cell: Water bottles can be either disposable or reusable.
A5 cell: Disposable water bottles are often sold filled with potable water, while reusable bottles are often sold empty.
A6 cell: Reusable water bottles help cut down on consumer plastic waste and carbon emissions.
Thanks