Filtering (I'm guessing)

Giganews Newsgroups
Subject: Filtering (I'm guessing)
Posted by:  I'm guessing (Filtering)
Date: Mon, 15 May 2006

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

Replies