How do I search for keywords in cells containing text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of cells containing different descriptions. Is there an easy
way to search among these cells for certain keywords?
 
Several ways. What are you trying to do, can we see some example data?

Mike
 
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.
 
Fredrik,

What is it that you want to do? Know if a keyword is there?

=COUNTIF(A1:A100,"*keyword*")>0
will return TRUE if the keyword is present in any string in A1:A100.

=COUNTIF(A1:A100,"*keyword*")
Will return the number of occurences of keyword

Array entered (enter using Ctrl-Shift-Enter)
=ADDRESS(MIN(IF(ISERROR(FIND("keyword",A1:A100)),1000,ROW(A1:A100))),1)
Will return the address first cell that contains keyword

HTH,
Bernie
MS Excel MVP
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a single word match in a text string and assigning a code 8
Extract text within two specific values within a cell 1
Searching for keyword in sheet 1 and returning the whole row intosheet 2 4
Format single words in cells 3
Multiple conditional formating for one cell 2
Search formula referencing range of keywords 5
extracting text between two keywords 6
The best way to create a Keyword Seach field in excel 1

Back
Top