View Single Post
  #2   Report Post  
Old January 7th 10, 06:57 PM posted to microsoft.public.excel.misc
Arceedee Arceedee is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 96
Default Count specific characters in a cell

It can be done by splitting the data into separate columns and then using a
countif formula but that may not be feasable in the s/s. If you have a whole
column of similar data then it's simple to use the Text to Columns feature.
More info would help.

I hope someone can come up with a way because that would be helpful to me
also.




"JGreg7" wrote:

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