Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific characters in a cell
Hello,
Can someone help me out. I'd tried to find a formula which shows for me how many times a specific character, for example the letter "a", is written in a cell. Example: cell a2: "this is a test" Cell b2 "3" (= character s exist 3 times in cell a2). regards, Johan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific characters in a cell
Try this
=LEN(A2)-LEN(SUBSTITUTE(A2,"s","")) Mike "johan" wrote: Hello, Can someone help me out. I'd tried to find a formula which shows for me how many times a specific character, for example the letter "a", is written in a cell. Example: cell a2: "this is a test" Cell b2 "3" (= character s exist 3 times in cell a2). regards, Johan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting specific characters in a cell
Thanks a lot.
Works very well. regards, Johan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters within a cell | Excel Worksheet Functions | |||
Counting characters in a cell | Excel Discussion (Misc queries) | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
counting characters in a cell | Excel Discussion (Misc queries) | |||
Counting Characters in a Cell | Excel Worksheet Functions |