Rational
Count a number of characters in a text string.
Description
The Excel LEN function counts a number of characters (letters & symbols) of a given text strings excluding number formatting like $ or % in a digit. For example, LEN(“Excel”) returns “5”.
Syntax
=LEN (text)
Parameters
text – The text to find the length.
Return Value
An integer referring the length of a text string.
Key Notes
- The LEN function is handy to calculate length of text, number, and dates.
- LEN function return number of characters of a text as it stores, not the way Excel display it. For Example, The LEN function count characters excluding number formatting (i.e. the length of “$100.00” is 3).
- Also, account for characters after decimals.
In Excel LEN function also include length of space like here in cell B6 it returns 18 i.e. it count space with string.
Keep Reading Similar Functions:
SEARCH
The SEARCH function finds the position of a specified character or sub-string within a text string. I.e., =SEARCH(“ring”,”String”,1) return “3”, “ring” begins at the third character of “String”.
EXACT
The Excel EXACT function display (True or False) after matching two text strings if they are exactly same. Also identifies case-sensitive differences between two text.
FIND
The FIND function displays the numerical position of the character in a string. I.e. to find the 2nd occurrence of 8, =FIND(8,128128,4) returns 6.