Related Topics:
	Spreadsheet Math Functions Formulas Tab and Insert Function Data Entry Tips for Functions Function Wizard

LEN

Description: Returns the number of characters in a text string.

Syntax: LEN(Text)

• Text is the text whose length you want to find. Spaces count as characters.

Example:

Suppose A1:A3 contain "Phoenix", "AZ" and " ".

• LEN(A1) = 7 [the length of the first string]

• LEN(A3) = 0 [the length of the third string]

• LEN("   One  ") = 8 [the length of the string, which includes 5 spaces]

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link