count based on text length
now browsing by tag
LEN function type: Text
Description: Returns the number of characters in a text string
LEN is a basic function widely used, many formulas built for text processing will need this function.
Take a look at the advanced applications examples:
- Get the text with the lowest length from a column (first match only)
- Count how many cells within a range of cells have a text length higher than normal