try this

put this formula in C1 =SUM((MID(A1,COLUMN(1:1),1)=B1)*1)

use ctrl + shift + enter





On Oct 12, 12:17*pm, Eric wrote:
Does anyone have any suggestions on how to count the number of occurrence
within string? For example, aa11bb5c in cell A1, and "a" in cell B1, I would
like to count the number of occurrence for the char "a" in cell B1 within
string "aa11bb5c" in cell A1, and return the number of occurrence 2 in cell
c1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric