is there a way to add up words in a sentence in excel? for example in A1 I have "the cow jumped over the moon" and in cell A2 I have " but the cow and the cat had a milk moon pie". and I wanted to add up how many times the word "cow" or "moon" are typed in my sentence's.
|the cow jumped over the moon||2||4||2|
|but the cow and the cat had a milk moon pie|