| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i set up a character count for a specified cell?? | Excel Discussion (Misc queries) | |||
| how can I count (countif) the character: * | Excel Worksheet Functions | |||
| Character Count | Excel Worksheet Functions | |||
| ... Count Function ... with any character ... | Excel Discussion (Misc queries) | |||
| How do i count character in cell? | Excel Discussion (Misc queries) | |||
Linear Mode
