LEN, LENB functions: Description, Usage, Syntax, Examples and Explanation
What are LEN, LENB functions in Excel?
LEN, LENB functions are TEXT functions in Microsoft Excel.
Important:
- These functions may not be available in all languages.
- LENB counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise LENB behaves the same as LEN, counting 1 byte per character.
The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.
Syntax of LEN, LENB functions
LEN(text)
LENB(text)
The xxx function syntax has the following arguments:
- Text: The text whose length you want to find. Spaces count as characters.
Example of LEN, LENB functions
Example 1: LEN
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.
You can adjust the column widths to see all the data, if need be.
| Data | ||
| Phoenix, AZ | ||
| One | ||
| Formula | Description | Result |
| =LEN(A2) | Length of the first string | 11 |
| =LEN(A3) | Length of the second string | 0 |
| =LEN(A4) | Length of the third string, which includes 5 spaces | 11 |
Example 2: LENB
Note: First set to your computer to a default language that supports DBCS
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.You can adjust the column widths to see all the data, if need be.
| Data | ||
| Phoenix, AZ | ||
| One | ||
| Formula | Description | Result |
| =LEN(A2) | Length of the first string | 11 |
| =LEN(A3) | Length of the second string | 0 |
| =LEN(A4) | Length of the third string, which includes 5 spaces | 11 |