Count the times a specific character appears in a cell

  • Thread starter Thread starter hl
  • Start date Start date
H

hl

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