The LEN and LENB functions in Excel are essential tools for managing text data. These functions allow users to find out the number of characters in a string, which can be helpful for data validation, analysis, and preparing datasets for import or integration with other applications. While LEN counts characters in any given text, LENB focuses specifically on the byte size of the text, which is particularly useful in certain languages and data formats.
Syntax
LEN(text)
LENB(text)
- text: The input string for which you want to determine the character count. This can be a cell reference or a direct string enclosed in quotes.
Example #1
=LEN("Hello, World!")
This function counts the characters in the string “Hello, World!”, returning 13, as it includes all letters, punctuation, and spaces.
Result: 13
Example #2
=LENB("你好")
Using LENB on the Chinese characters “你好” counts the byte size rather than the character count, resulting in 4. Each character is represented as 2 bytes.
Result: 4
Example #3
=LEN(A1)
Assuming cell A1 contains the text “Excel Functions”, this function measures how many characters are in that specific string, returning 16 as the length.
Result: 16
Error handling
- VALUE! – This error occurs when the input cell contains an invalid value or when the input is not a text string.
- REF! – This error can arise if the referenced cell is deleted or inaccessible.