| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I search for keywords in cells containing text?
I have a column of cells containing different descriptions. Is there an easy
way to search among these cells for certain keywords? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I search for keywords in cells containing text?
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I search for keywords in cells containing text?
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I search for keywords in cells containing text?
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)),1 000,ROW(A1:A100))),1) Will return the address first cell that contains keyword HTH, Bernie MS Excel MVP "Fredrik" wrote in message ... I have a column of cells containing different descriptions. Is there an easy way to search among these cells for certain keywords? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help!! Want to search through 3 columns for a list of keywords | Excel Worksheet Functions | |||
| Using IF function in excel to search for text across cells and she | Excel Worksheet Functions | |||
| Keyword search, several keywords | Excel Discussion (Misc queries) | |||
| Specific keywords copying data to cells | Excel Worksheet Functions | |||
| can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions | |||
Linear Mode
