character count

[Guest]

hi,
How to count the character count in a particular cell.
Ex:
A1="Welcome to Excel"
count e in A1

e in = 4

by
Iram

 

[Guest]

Try,

=LEN(A1)-LEN(SUBSTITUTE(A1,"e",""))

Mie

 

[Guest]

Sorry you want both cases so try

=LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE(A1,"e",""),"E",""))

instead.

Mike

 

[David Biddulph]

=LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),"e",""))