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

"Dave Peterson" wrote:

=(len(a1)-len(substitute(a1,"good","")))/len("good")


Mike G wrote:

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?

--

Dave Peterson

Reply With QuoteReply With Quote