Solve : excel question.?

1.	Solve : excel question.?
Answer» suppose if I have a list of name and I want to know how MANY of the names contain less than 5 character. How do I do it? The "len" function returns the NUMBER of characters in a text string. So suppose you had the names in cells A1 to A50. In CELL B1, PUT =len(A1). Copy/paste that down the B column. Then USE =countif(B1:B50,"<5") in the next cell. Or did you want <= 5, I forget. If you wanted that, use <= 5 (or < 6).

Discussion