Thread: Counting # of occurances of words in text
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default Counting # of occurances of words in text
=(LEN(A1)-LEN(SUBSTITUTE(A1,"good","")))/4

If the word to serch is in a particular cell, say B1, then:
=(LEN(A1)-LEN(SUBSTITUTE(A1,B1,"")))/LEN(B1)


"Mike G" wrote in message
...
If I have a cell that contains "good things come in good packages" and
want to count the number of occurances of the word "good" how would I do
that? Have tried countif and sumproduct and both give me #name?



Reply With QuoteReply With Quote