word count with numbers embedded within text

[labmanager]

Hello there!


I need excel to generate word counts, but I have embedded numbers within the text which I don't want to be included in the count. Example: "21 I went to the store with my grandma 22 and then bought some candy. 23 Afterward, we went home".

I would want a count of the words that doesn't include the numbers (20 vs. 17).

Thanks in advance!

[Ace_XL]

A bit long-wounded

=LEN(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""),0,"")))-LEN(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""),0,""))," ",""))+1