Count words having more than one character in a cell

**Admin** · 03-13-2012, 01:15 PM

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.

**Rick Rothstein** · 03-13-2012, 08:29 PM

Originally Posted by Admin

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))