List of cells that contain a particular word

  • Thread starter Thread starter cloudyMalta
  • Start date Start date
C

cloudyMalta

Hi,

I have a sheet with a list of items. One column has a description and I need
to find all the description cells that contain "North America" for example.
What can I use.

Thanks and Regards

Claudio
 
Hi

Data>Filter>Autofilter>select dropdown on relevant
column>Custom>Contains>"North America"
 
One way
Assuming the descriptions are running in B2 down
Put in C2: = -- ISNUMBER(SEARCH("North America",B2))
Copy down to last row of data in col B. Col C returns "1" where the word is
found. Apply autofilter on col C, filter for "1". Copy n paste the filtered
results elsewhere.
 
Back
Top