Miquel,

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

Mike

"Miguel Zapico" wrote:

Depending on what you mean with "Extract". This formula in column C will
show a different value if there is a dog in column B or not:
=IF(ISERROR(FIND("dog",B1)),"No dog","Dog found")
Is this what you are looking for?
Miguel.

"Filtering (I'm guessing)" wrote:

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