The LENB function returns the length of a string in bytes.
Parts of a LENB function
LENB(string)
| Part | Description |
string
|
The string to get the length in bytes |
Notes
LENB
returns the same value as LEN
if the input string has only single byte characters.
Examples
| A | B | C | |
|---|---|---|---|
|
1
|
Input | Formula | Output |
|
2
|
Aeñ | =LENB(A2)
|
3 |
|
3
|
Aeñ | =LEN(A3)
|
3 |
|
4
|
熊本
|
=LENB(A4)
|
4 |
|
5
|
熊本
|
=LEN(A5)
|
2 |
Related functions
- MIDB : The MIDB function returns a section of a string starting at a given character and up to a specified number of bytes.
- LEFTB : The LEFTB function returns the left portion of a string up to a certain number of bytes.
- RIGHTB : The RIGHTB function returns the right portion of a string up to a certain number of bytes.
