Counting specific characters in a cell

[johan]

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

 

[Mike H]

Try this

=LEN(A2)-LEN(SUBSTITUTE(A2,"s",""))

Mike

 

[johan]

Thanks a lot.

Works very well.

regards,
Johan