LENB function

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



text is the text string whose number of bytes is to be determined.

LENB is intended for use with languages that use the double-byte character set (DBCS). LENB counts each double-byte character as 2 when you have enabled the editing of a language that supports DBCS and then set it as the default language. Otherwise, LENB counts each character as 1.


LENB("上午") returns 4.

LENB(12345.67) returns 8.