LEN () and LENB () Functions in Excel

This article provides a clear overview of LEN () and LENB () Functions in Excel, with the main facts, useful context, and practical details organized for easy reading.

If you do not know how to use the LEN () and LENB () functions, you follow the article below.

The article describes the syntax and usage of the LEN () and LENB () functions in Excel.

Description

The LEN () function returns the number of characters in the input text string.

The LENB () function returns the number of bytes used to represent characters in the input text string. The LENB function only comes to 2 bytes per character when the default language is one of the languages that supports DBCS.

Syntax

= LEN (text)

= LENB (text)

Where: text is the input text string that you may need to find its length, counting both spaces and required parameters.

For Example

LEN ()

Count the number of characters of the string TipsMake. vn

= LEN ("TipsMake. vn")

You can also refer to the text with a data box containing text for example: = LEN (B6)

The LENB () function you use is similar to the LEN () function, but when using the LENB function, the default language of your computer and Office must be set as one of the languages that support DBCS. Otherwise LENB () will return the same result as LEN ().