LENB
For double-byte character set (DBCS) languages, returns the number of bytes used to represent the characters in a text string.
LENB("Text")
āĻĒāĻžāĻ ā§āĻ¯ āĻšāĻ˛ā§ āĻĒāĻžāĻ ā§āĻ¯ āĻ¯āĻžāĻ° āĻĻā§āĻ°ā§āĻā§āĻ¯ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖ āĻāĻ°āĻž āĻšāĻŦā§āĨ¤
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.