The Excel LEN function is used to find the length, in number of characters, of the contents of a cell.
The syntax for the LEN function is:
=LEN(text)
| Argument | Purpose |
|---|---|
| Text | The reference to the cell whose length you want to find |
The example below shows the LEN function being used to find the length, in number of characters, of the cells in column A.
