“LEN”
Used for – “LEN” function in MS Excel is
used to count the number of characters in a text string or in a cell.
Syntax – LEN(text).
Example – Following example will clear
the LEN function:
A

B

C

D

E

F

G

H

I


1

EXCEL

WITH

EASE


2

=LEN(“EXCEL WITH EASE”)

=LEN(B1)

=LEN(C1)

=LEN(D1)


3


4


5


6


7

And
result you get as under:
A

B

C

D

E

F

G

H

I


1

EXCEL

WITH

EASE


2

15

5

4

4


3


4


5


6


7

Note:
The LEN Function counts each character in the text string and if there are any
extra spaces are typed in the string it will count them too. So you should be
more careful using this function