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

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
>
>
>

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)" 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
>
>
>

Elker,

Thank you. You were right on the money.

Mike

"Elkar" wrote:

> 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)" 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
> >
> >
> >

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
> >
> >
> >