Count specific characters in a cell
Note that this is case sensitive.
If A1 = aBC123ABC the formula will return 1. Only the upper case "A" is
being counted. Likewise, if the formula was:
Then in this case only the lower case "a" will be counted.
If you want to ignore case then try this version:
That will count both lower and upper case "a" or "A".
Microsoft Excel MVP
"JGreg7" wrote in message
Is there a way to count the number of times a specific character occurs in
For example, if cell A1 has "ABC123ABC" and I wanted to count the number
occurances that "A" showed up, and wanted the out put to be in B1. In
example the desired result would equal "2".