=LEN(B2)-LEN(SUBSTITUTE(B2,"#",""))
HTH
Jason
Atlanta, GA
-----Original Message-----
How can a frequency of a specific character be counted
with in a cell. Ex -"
#4 Bluebirds, #6 Aquatic" is in cell B2 - how do I count
the number of "#"
that appear in cell B2?
.
|