Quote Originally Posted by Admin View Post
Rick,

I think you mis-interpreted the sentence. My formula would give you the count of those words only which have more than one character in a cell.
Yes, you are right... I did mis-interpret your sentence. Sorry for any confusion that may have caused. However, with that said, there is still a direct (although not all that simple) formula available to obtain this count...

=SUMPRODUCT(1*(LEN(TRIM(MID(SUBSTITUTE($A3," ",REPT(" ",999)),ROW(INDIRECT("A1:A999"))*999-998,999)))>1))