Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

LEN

Count a number of characters in a text string in Excel
Return number of Characters of a String

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.
LEN function also count wildcard characters with text for example you have “Char*acter” and you put formula =LEN(“Char*acter”) it return 10.
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:

Finds position of one text value within another Text in Excel

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”.

Read More »
Return character position of a text in Excel

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.

Read More »
Match two text strings if they are exactly same in Excel

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.

Read More »