Here is a UDF (user defined function) that will output the values you are asking for...
Code:
Function CountSBW(ByVal S As String, Instance As Long) As Variant
Dim X As Long
On Error GoTo NoSuchInstance
S = Replace(Trim(S), " ", Chr(1))
For X = 1 To Len(S)
If Mid(S, X, 1) Like "[!" & Chr(1) & "]" Then Mid(S, X) = " "
Next
CountSBW = Len(Split(Application.Trim(S))(Instance - 1))
Exit Function
NoSuchInstance:
CountSBW = ""
End Function
The SBW in the function's name is short for "Spaces Between Words". To use this function, pass it the text that you want to parse as the first argument and the instance of the group of spaces you want to count. So if the first text to be parsed is in cell A1, put this formula in cell B1 (normally entered)...
=CountSBW($A1,COLUMNS($B:B))
and copy it across for as many columns as you think you will ever have groups of spaces between words to parse, then copy all of those formulas down to the bottom of your data. Note that you should change the two B column references to whatever the column letter is for the column that the first formula is placed in.
HOW TO INSTALL UDFs
------------------------------------
If you are new to UDFs, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. That's it.... you are done. You can now use
CountSBW just like it was a built-in Excel function. For example, as shown above...
=CountSBW($A1,COLUMNS($B:B))
If you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.