LENB Function. Get the length (in bytes) of a string.
Get the length (in bytes) of a string.
How it works
=LENB(string)
| Name | Omission | Specify |
|---|---|---|
| string | Required argument. | A string that counts the number of bytes. |
Demonstrate
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.
Spill
If the argument were a cell range, it would be Spill.
---