View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

=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?
.