LENB

This function returns the number of bytes used to represent the characters in a text string.

Syntax

LENB(text_value)

Arguments

[Required] The argument is the text whose length you want to find. Spaces in the specified text value are counted as characters. The argument must be a string or a cell reference to a string value.

Remarks

The LENB function counts 2 bytes per character, but this happens only when a DBCS language is set as the default language.

Examples

LENB("rheabuto") gives the result 8

LENB("rosy") gives the result 4