Hello,
I am trying to find the "true" word count of a cell. Please see attached file. I need it to exclude any numbers, characters, etc, just count real words.
Formula IF(LEN(TRIM(A2))=0,0,LEN(TRIM(A2))-LEN(SUBSTITUTE(A2," ",""))+1) returned 9, but it should return 6, when counts only # of real words.
Is this possible?
Thanks
Bookmarks