|  

» 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


Rate This Tip
12 34 5
Rating: 3.73     Views: 84688
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments