![](https://xlncad.com/wp-content/uploads/2020/07/LEN_1.png)
Table of Contents
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
![](https://xlncad.com/wp-content/uploads/2020/07/LEN_1-1.png)
Notes
LEN function counts numbers as well as space character but ignores ‘Number Formatting’.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)