LEN

The LEN function is used to count the number of characters in a text string. It is a simple yet powerful function that comes in handy when you need to quickly determine the length of a cell's content.

Syntax

=LEN(text)

text The text string for which you want to count the characters.

About LEN

When you find yourself in a situation where you require the precise count of characters present in a text string within Excel, the LEN function emerges as your go-to tool. By simply supplying the function with the desired text string, it swiftly returns the total number of characters present within that text, including spaces and special characters. This functionality is particularly useful for various data analysis tasks, such as validating the length of input data or manipulating text-based information.

Examples

If you have the text 'Hello, Excel!' in cell A1, and you want to find out how many characters are in that text, you would use the formula: =LEN(A1). This will return the value 12, indicating that the text string consists of 12 characters.

Suppose you have a list of product descriptions in column B starting from B2 downwards, and you want to quickly determine the length of each description. You can use the formula =LEN(B2) in cell C2 and drag it down to apply the formula to the entire list, revealing the character counts for each description.

Questions

What does the LEN function count as characters?

The LEN function counts every character present in the specified text string, including letters, numbers, spaces, and special characters. All characters are taken into account for the total character count.

Can the LEN function be used for numerical values or dates?

Yes, the LEN function can be used to count the number of characters in numerical values or dates when they are presented as text in a cell. However, for actual numerical or date calculations, it is recommended to use appropriate Excel functions designed for those types of data.

Is the count provided by the LEN function case-sensitive?

No, the LEN function is not case-sensitive. It counts all characters, regardless of whether they are uppercase or lowercase letters, as one character each. Case differences do not impact the character count.

Related functions

LEFT
RIGHT
MID
SUBSTITUTE
FIND
SEARCH
REPT
TEXT
TRIM