How to count the number of occurrence within string?
 

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

How to count the number of occurrence within string?
 

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

How to count the number of occurrence within string?
 

Try this in C1...

=LEN(A1)-LEN(SUBSTITUTE(A1,B1,""))

--
Rick (MVP - Excel)


"Eric" wrote in message
...
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