ExcelBanter - character count

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - character count (https://www.excelbanter.com/new-users-excel/157290-character-count.html)

Mariappan

character count

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

character count

Try,

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

Mie

"Mariappan" wrote:

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

character count

Sorry you want both cases so try

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

instead.

Mike

"Mariappan" wrote:

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

David Biddulph[_2_]

character count

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

"Mariappan" wrote in message
...
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

All times are GMT +1. The time now is 03:05 PM.