Hi All,

Here is a formula based solution to count words having more than one character in a cell.

If you have data in A2:Ax on Sheet1,

select B2 (It's very important)

Hit CTRL + F3 (to open the Name Manager)

Click on New ;

Name: String

Refers to: =EVALUATE("{"""&SUBSTITUTE(Sheet1!$A2," ",""";""")&"""}")

Now in B2 and copied down,

=INDEX(FREQUENCY(LEN(String),{1}),2)

Hope this helps !