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