Counting the Occurence of Special characters in Single/Multiple cells?
Lets say i have a cell containing special characters like "-"'s dashes or "*" asteriks in a single cell..
How do I count the occurence in a single cell..
EX1- B2 contains the text A*12*34*56*78*910..
Now what formula would give me an answer , that there are 5 asteriks,,
Countif(Range,"*")?
Bookmarks