View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johan johan is offline
external usenet poster
 
Posts: 34
Default 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