Tip Printed from ExcelTip.com
Counting how many times specific character appears in cell in Microsoft Excel



Text in cell A1:	       Are you going to Disney ?
 
The Character:            o in cell A2

The Function:             =LEN(A1)-LEN(SUBSTITUTE(A1,A2,""))

Result:                   3