Advanced Excel Statistical - LEN Function

Description

LEN returns the number of characters in a text string.

LENB returns the number of bytes used to represent the characters in a text string. It 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

LEN (text) 
LENB (text)

Arguments

Argument	Description	Required/ Optional
Text	The text whose length you want to find. Spaces count as characters.	Required

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm