LENB Function. Get the length (in bytes) of a string.

Japanese version.

Get the length (in bytes) of a string.

How it works

stringRequired argument.A string that counts the number of bytes.


The LEN function counts characters while the LENB function counts bytes.

Half-width characters are counted as 1, while full-width characters are counted as 2 or more in the LENB function.

Line break in a cell, is counted as 1 as in the LEN function.


If the argument were a cell range, it would be Spill.



Microsoft Excel Functions Text