Share this article:

What it does: The LEN() function returns the length (number of characters) of a given text or string.

Plain English: This formula returns the number of characters in a string that you specify. The string can either be in “quotes” or a cell reference.

  • Example 1: Len(“John”) = 4
  • Example 2: Len(“John Smith”) = 10

This formula is one of the foundations of cleaning data because in conjunction with other text formulas it helps you measure exactly what’s going on inside a cell.

Arguments: LEN(Text)

  • Text – The only argument it takes is the text you want to measure.

NOTE: In the second example above, notice how “John Smith” has a length of 10. That is because this formula also counts other characters like spaces, dashes, colons, single quotes, parentheses, etc…

Please remember that we may receive commissions when you click our links and make purchases