View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] hl@greenreefers.no is offline
external usenet poster
 
Posts: 15
Default Count the times a specific character appears in a cell

I am trying to count the number of times a specific character appears
in a cell (or range of cells). Anyone know how to do this?

Example: The cell contains "Fruit/Meat/Fish" and I would like a
formula counting the number of times "/" appears (returning the value
2).

Brgds,
Harald