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

Count the times a specific character appears in a cell
 

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

Count the times a specific character appears in a cell
 

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

--
Gary''s Student - gsnu2007k

Count the times a specific character appears in a cell
 

Brilliant. Thanks!