Excel > Functions
LEN Function
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.
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
