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

Put this in b1 and the character you want to count in A2

"- - - - -" wrote:

hi,
i want to calculate the following;
CELL A1 HAS A VALUE = RG/351/87/11/3
1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL
2- HOW MANY "3" (THREE) IN THIS CELL.
ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC
WORD/NUMERIC/SPECIAL CHARACTER IN A CELL.
THANKS FOR YOUR COOPERATION.
I HOPE I WILL GET IT SOON.

SAQIB YAQUB