View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JGreg7 JGreg7 is offline
external usenet poster
 
Posts: 15
Default Count specific characters in a cell

Is there a way to count the number of times a specific character occurs in a
specific cell?

For example, if cell A1 has "ABC123ABC" and I wanted to count the number of
occurances that "A" showed up, and wanted the out put to be in B1. In this
example the desired result would equal "2".

--
Thank you,
John Gregory