Counting Special Characters In a Cell - Getting Formula Error on Excel 2010

[RuaanKraft]

Hi Guys,

I've watched Videos and checked out your forums but I'm still not getting the formula to work! The following formula as example won't work in my Excel 2010:

=LEN(A7)-SUBSTITUTE(A7,"e",""))

In cell A7 I've got the Word "Agree"

 

[ttdk1]

Formula looks fine. Maybe your excel 2010 is different

 

[hiker95]

RuaanKraft,

How about this?

Excel 2007
	A	B
7	Agree	2
Sheet1

Cell Formulas
Range	Formula
B7	=LEN(A7)-LEN(SUBSTITUTE(A7,"e",""))

 

[Rick Rothstein]

How about this?

Excel 2007

	A	B
7	Agree	2

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B7 =LEN(A7)-LEN(SUBSTITUTE(A7,"e","")) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

That looks like the same formula that the OP was told to use back in Messages 6 and 7 to which the OP replied he was getting a formula error. The next set of responses asked if the OP used semi-colons instead of commas to delimit function arguments... the OP has not gotten back to us yet on that question.

 

[RuaanKraft]

Thanks Guys, i've got it working, had to replace the comma's with semicolon's. Working now.

=LEN(A7)-LEN(SUBSTITUTE(A7;"e";""))