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.

LEN function finding the length of cell contents

Follow us on

Facebook  Twitter  You Tube 

Other Text Functions

Excel 2010 Superhero Course