LENB

For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string.

LENB("Text")

Text is the text whose length is to be determined.

LENB("中") returns 2 (1 DBCS character consisting of 2 bytes).

LENB("中国") returns 4 (2 DBCS characters each consisting of 2 bytes).

LENB("office") returns 6 (6 non-DBCS characters each consisting of 1 byte).

=LENB("Good Afternoon") returns 14.

=LENB(12345.67) returns 8.