# 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.

**LEN**returns the number of characters in a text string.While,

**LENB**returns the number of bytes used to represent the characters in a text string.

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 |