Skip to main content

LENB

The LENB function returns the length of a string in bytes.

This function can be useful for determining the actual size of text data in bytes, which is important when working with multi-byte encodings where a single character can occupy more than one byte.

Syntax​

LENB(string)

ArgumentDescriptionPermitted values
stringText whose length needs to be returnedText string or reference to a cell containing text

Examples of use​

Calculating the length of the text in cell A1

=LENB(A1)

The result will be equal to the number of bytes occupied by the text in this cell.

Determining the length of a specific text string

=LENB("Hello")

The result will show the number of bytes required to store the word “Hello” (5 bytes).

Notes​

  • The LENB function takes into account the bytes that may be required to represent characters. This is particularly important if the text contains characters that are larger than one byte.
  • If the argument is not text, it will be automatically converted to text before calculation.