Counting specific characters in a cell

  • Thread starter Thread starter johan
  • Start date Start date
J

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
 
Back
Top