Finding the most frequent word -edited

[cadbury07]

Hi, I have a problem finding the most frequently occurring word in Excel. The problem is that I have also compound words such as:

Export
Exportprice

(These are just examples)

I want that the word "export" is added twice.
I have 2 columns. Column A includes the words, column B the number of their occurrence. I have many words and I need to check every single word.

How do I do that please? I would appreciate any help since I need to do this for my thesis

 

[Aladin Akyurek]

E2: Export

F2:

=SUMPRODUCT(ISNUMBER(SEARCH(E2,$A$2:$A$20))+0)

which counts the occurrences of the substring of E2 in A2:A20.

 

[cadbury07]

I do not have a predetermined list of words, so to be able to use this formula, I would have to type every single word. I cannot do that since I have a long list.

 

[Aladin Akyurek]

I do not have a predetermined list of words, so to be able to use this formula, I would have to type every single word. I cannot do that since I have a long list.

Care to post a small sample and describe the task/problem regarding that sample along with the desired results.

 

[cadbury07]

Hi, I solved the problem.