Filtering (I'm guessing)

[Filtering (I'm guessing)]

Anybody know how I would extract Excel cells that contain a specific item of
information?

For example: I would like to extract the cells below that contain the word
"dog":
Cell B1 --> cat, dog, fish
Cell B2 --> cat, fish, cat
Cell B3 --> dog, fish, cat
Cell B4 --> fish, dog, fish
Cell B5 --> cat, cat, fish

Is there a comand that would extract cells B1, B3, B4 that contain the word
"dog"?

Thanks, Mike

 

[Elkar]

Select your column of data. From the Data Menu, select Filter, then
AutoFilter.

You should now see a dropdown arrow in the header row of your column.

Click the arrow, then select "Custom" from the list. Change the selection
to "Contains" and then type in "dog".

HTH,
Elkar

 

[Filtering (I''m guessing)]

Elker,

Thank you. You were right on the money.

Mike

 

[Filtering (I''m guessing)]

Miquel,

Thanks, I'll work with it. I see the approach that you are taking.

Mike