Table of Contents
Summary
The Excel LEN function returns the number of characters in a text string.
This function is useful for determining the number of characters in a cell.
Function
=LEN(text)
Arguments (inputs)
text = the text string, can be a cell reference or value
Return value
The LEN function returns numerical value that is a count of the characters of a text string from a cell reference or input.
Example
In the example above the LEN function counts the number of characters in the cell C6, the customer name “Claire Gute”.
=LEN(C6)
The result returned is 11.
