Counting the Frequencies of Words in Excel Strings -

Suppose I have a column of arbitrary length, where each cell has a string of text. Is there a way to determine which words appear most often in the column (to check the words not knowing in advance) and later by directing these words in sequence with their frequencies of two frequencies Can you? What VBA would be best for this task?

As an example, string in a cell "This can be a string, and it has # characters of the string> 0." (Errors intentionally)

Choose a part of the column A and this small The macro will be placed in columns (colored.) B & C :

  Sub Ftable () String in the form of slow BigString I used to do yoga to separate 'both' and '' all '' codes, as tall as Long, J. BigString = ""  

Add the code for "" "!" Etc. The word is preceded by them, hence the word ' For example: "All." Should not be described as 1 'All'. But the word "all" should be added to the total number of words "all" For each R in the selection BigString = BigString & amp; r.Value Next R. BIGSTROGREING = Trim (BIGSTROWING) ary = Split (BigString, "") Setting the collection as Dim cl to CL = New for each one Resume error in the archive cl.Add a Sistiar (A) for the next one I count = 1 Cl V = Cl (I) cell (I, "B"). Value = vj = 0 for every one if a = v then j = j + 1 one cell forward (i, "c") = j next i sub

Ends