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

"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