character count

Thread view:

Thread rating:

Mariappan - 06 Sep 2007 13:48 GMT

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

Mike H - 06 Sep 2007 13:56 GMT

Try,

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

Mie

> hi,
> How to count the character count in a particular cell.
[quoted text clipped - 6 lines]
> by
> Iram

Mike H - 06 Sep 2007 14:08 GMT

Sorry you want both cases so try

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

instead.

Mike

> hi,
> How to count the character count in a particular cell.
[quoted text clipped - 6 lines]
> by
> Iram

David Biddulph - 06 Sep 2007 14:18 GMT

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

Signature

David Biddulph

> hi,
> How to count the character count in a particular cell.
[quoted text clipped - 6 lines]
> by
> Iram