How do I search for keywords in cells containing text?
Select the table, then use Data / Filter / Autofilter. Select the dropdown at the top of the
column, select (Custom...), then look for "Contains" (second last option) and type "Turbo" into the
box, then click OK.
HTH,
Bernie
MS Excel MVP
"Fredrik" wrote in message
...
I have a list of cars with descriptions, so if I somehow search for 'turbo',
I want the cars with turbo in the description field to appear. Note that the
description cells contain complete sentences, where 'turbo' is only one of
the words.
"Mike H" wrote:
Several ways. What are you trying to do, can we see some example data?
Mike
"Fredrik" wrote:
I have a column of cells containing different descriptions. Is there an easy
way to search among these cells for certain keywords?
|