| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF for single word in text
How can i COUNTIF for the word "travel" in a cell which reads, "travel status
thru 6-1-07" or the like? thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for single word in text
There are a few ways to do this. Here is the most generic way for a range of
cells: =COUNTIF(A1:A10,"*travel*") Biff "jewelybrook" wrote in message ... How can i COUNTIF for the word "travel" in a cell which reads, "travel status thru 6-1-07" or the like? thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for single word in text
=COUNTIF(A:A,"*travel*")
"jewelybrook" wrote: How can i COUNTIF for the word "travel" in a cell which reads, "travel status thru 6-1-07" or the like? thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for single word in text
thank ya'll!
"T. Valko" wrote: There are a few ways to do this. Here is the most generic way for a range of cells: =COUNTIF(A1:A10,"*travel*") Biff "jewelybrook" wrote in message ... How can i COUNTIF for the word "travel" in a cell which reads, "travel status thru 6-1-07" or the like? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split Text to columns using an entire word, not just a single cha | Excel Discussion (Misc queries) | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| Using COUNTIF for a word that is joined by another word in same ce | Excel Discussion (Misc queries) | |||
| exporting single cells to Word | Excel Discussion (Misc queries) | |||
| COUNTIF text where there is more than one word in a cell | Excel Worksheet Functions | |||
Linear Mode
