Try this


=LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))

Mike

" wrote:

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