LEN Function

About

LEN function in Excel returns the length of a text string.

Function Type

Text

Purpose

Get the length of a text string

Return value

A number equivalent to the count of characters in the text

Syntax

=LEN(text)

Arguments

text – the text string of which length is to be retrieved


Example


Notes

LEN function counts numbers as well as space character but ignores ‘Number Formatting’.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel