Create test on String Length with LEN
The LEN function returns the number of characters is a cell. It's very useful if you have to check the length of names, codes, references
LEN
Count Words in an Excel cell
How to count the number of words in an Excel cell? With Excel, you can use 2 techniques to return this result.