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