software

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
quot;dogquot;:
Cell B1 --gt; cat, dog, fish
Cell B2 --gt; cat, fish, cat
Cell B3 --gt; dog, fish, cat
Cell B4 --gt; fish, dog, fish
Cell B5 --gt; cat, cat, fish

Is there a comand that would extract cells B1, B3, B4 that contain the word
quot;dogquot;?

Thanks, Mike

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

quot;Filtering (I'm guessing)quot; wrote:

gt; Anybody know how I would extract Excel cells that contain a specific item of
gt; information?
gt;
gt; For example: I would like to extract the cells below that contain the word
gt; quot;dogquot;:
gt; Cell B1 --gt; cat, dog, fish
gt; Cell B2 --gt; cat, fish, cat
gt; Cell B3 --gt; dog, fish, cat
gt; Cell B4 --gt; fish, dog, fish
gt; Cell B5 --gt; cat, cat, fish
gt;
gt; Is there a comand that would extract cells B1, B3, B4 that contain the word
gt; quot;dogquot;?
gt;
gt; Thanks, Mike
gt;
gt;
gt;

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 quot;Customquot; from the list. Change the selection
to quot;Containsquot; and then type in quot;dogquot;.

HTH,
Elkarquot;Filtering (I'm guessing)quot; wrote:

gt; Anybody know how I would extract Excel cells that contain a specific item of
gt; information?
gt;
gt; For example: I would like to extract the cells below that contain the word
gt; quot;dogquot;:
gt; Cell B1 --gt; cat, dog, fish
gt; Cell B2 --gt; cat, fish, cat
gt; Cell B3 --gt; dog, fish, cat
gt; Cell B4 --gt; fish, dog, fish
gt; Cell B5 --gt; cat, cat, fish
gt;
gt; Is there a comand that would extract cells B1, B3, B4 that contain the word
gt; quot;dogquot;?
gt;
gt; Thanks, Mike
gt;
gt;
gt;

Elker,

Thank you. You were right on the money.

Mike

quot;Elkarquot; wrote:

gt; Select your column of data. From the Data Menu, select Filter, then
gt; AutoFilter.
gt;
gt; You should now see a dropdown arrow in the header row of your column.
gt;
gt; Click the arrow, then select quot;Customquot; from the list. Change the selection
gt; to quot;Containsquot; and then type in quot;dogquot;.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Filtering (I'm guessing)quot; wrote:
gt;
gt; gt; Anybody know how I would extract Excel cells that contain a specific item of
gt; gt; information?
gt; gt;
gt; gt; For example: I would like to extract the cells below that contain the word
gt; gt; quot;dogquot;:
gt; gt; Cell B1 --gt; cat, dog, fish
gt; gt; Cell B2 --gt; cat, fish, cat
gt; gt; Cell B3 --gt; dog, fish, cat
gt; gt; Cell B4 --gt; fish, dog, fish
gt; gt; Cell B5 --gt; cat, cat, fish
gt; gt;
gt; gt; Is there a comand that would extract cells B1, B3, B4 that contain the word
gt; gt; quot;dogquot;?
gt; gt;
gt; gt; Thanks, Mike
gt; gt;
gt; gt;
gt; gt;

Miquel,

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

Mike

quot;Miguel Zapicoquot; wrote:

gt; Depending on what you mean with quot;Extractquot;. This formula in column C will
gt; show a different value if there is a dog in column B or not:
gt; =IF(ISERROR(FIND(quot;dogquot;,B1)),quot;No dogquot;,quot;Dog foundquot;)
gt; Is this what you are looking for?
gt; Miguel.
gt;
gt; quot;Filtering (I'm guessing)quot; wrote:
gt;
gt; gt; Anybody know how I would extract Excel cells that contain a specific item of
gt; gt; information?
gt; gt;
gt; gt; For example: I would like to extract the cells below that contain the word
gt; gt; quot;dogquot;:
gt; gt; Cell B1 --gt; cat, dog, fish
gt; gt; Cell B2 --gt; cat, fish, cat
gt; gt; Cell B3 --gt; dog, fish, cat
gt; gt; Cell B4 --gt; fish, dog, fish
gt; gt; Cell B5 --gt; cat, cat, fish
gt; gt;
gt; gt; Is there a comand that would extract cells B1, B3, B4 that contain the word
gt; gt; quot;dogquot;?
gt; gt;
gt; gt; Thanks, Mike
gt; gt;
gt; gt;
gt; gt;