Monday, 13 August 2012

Excel LEN Function Syntax and Example

LEN Function
The Excel LEN function is used to find the length of the string which may be a number or text.

Syntax:
=LEN(String)

Example:

STRING
LEN FORMULA
RESULT
Ravi-Teja@Reddy
 =LEN(A2)
15
Ravi-Teja@Reddy
 =LEN(MID(A3,FIND("@",A3)+1,5))
5
1234567890
 =LEN(A4)
10

Thanks,
TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts