List of cells that contain a particular word

[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

 

[Roger Govier]

Hi

Data>Filter>Autofilter>select dropdown on relevant
column>Custom>Contains>"North America"

 

[Max]

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.

 

[cloudyMalta]

Hi Roger,

Thank you very much for the reply and the speedy reply.

Amazing