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
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)