Counting character occurrences (Excel)

Number of times "x" in A2
=LEN(A2)-LEN(SUBSTITUTE(A2,"x",""))

Re

Look with this formula to count the FD from the range A1 to A50

=COUNTIF(A1:A50,"*FD*")

A+

Hi,

you also have something more complex, this formula

=SUM(LEN(E31)-LEN(SUBSTITUTE(E31,"FD","")))/LEN("DF")

Best regards,

Hello,

I would like to continue this conversation because I cannot solve the problem I am facing (despite desperately searching for hours...) :-/

Here is my data range (A1 to A5):

Too many offers are proposed
The description of the offers is not clear enough
The scrolling on the homepage is too fast
The offers are not interesting
Others

I want to know how many times the word "offers" appears in my list.

I wrote this formula:
=SUM(LEN(A2:A5)-LEN(SUBSTITUTE(A2:A5,"offers","")))/LEN("offers")

but I get this error "#VALUE!" in my cell.

Can you help me? :-/

Re,

It's the same, you identify your cell A1 for example and the result is 1 if the cell contains RFD-02
and 0 for RFCD-07 for example

=COUNTIF(A1,"*FD*")

A+

it's normal to divide by 2
with each occurrence you remove 2 characters
so the difference in the number of characters between the initial and after the substitution is 2 times too large
the result should not be divided by 2 but by the number of characters you remove

Thank you!

=SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(A1,"R","")))) gets me close to the result.
But how come it always gives me double the number of occurrences that I actually have?

And here it is:
Contents of a cell:
RFD-02
RFD-03
RFD-04
RFD-05 = RG-SYN-SIN4
RFD-06
RFD-08
RFD-30
RFD-07

Current formula:
=(LEN(L19)-LEN(SUBSTITUTE(L19,"FD","")))/2

Expected result: 8.

You will notice the subtle "/2" which is the only way I have found to get accurate results...
Thank you!

Hi,

Your formula works, but for a range of cells.
What I'm looking for is to count the occurrences of characters within a single cell...

Youhou !!

We made it, it's the right formula !!

I really thank you. Have a good evening!

instead of dividing by the length of the searched word, it is enough to replace the searched word not with an empty string but with a single arbitrary character....

=SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(A1,"R","x"))))