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"

 

[RoryA]

What exactly do you mean by "won't work" - what happens?

 

[RuaanKraft]

What exactly do you mean by "won't work" - what happens?

Getting an excel error " Your Formula Contains a Error "

Why do you think?

 

[RoryA]

Oh - remove the last ) from the formula.

 

[ttdk1]

ADVERTISEMENT

LEN(A7) returns a number. SUBSTITUTE returns a text string. Your formula tries to do a numerical calculation. It's like asking excel to calculate the value for 5 minus "Agr"

 

[Rick Rothstein]

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)-LEN(SUBSTITUTE(A7,"e",""))

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

You left out the part in red.

 

[VoG]

ADVERTISEMENT

Try

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

 

[RuaanKraft]

Try

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

Still getting the formula error?

 

[István Hirsch]

Do you happen to use the continental version of excel? If so, replace every comma with semicolon in the formula.

 

[Rick Rothstein]

Still getting the formula error?

What is the Excel delimiter between arguments in you locale... a comma like VoG and I suggested or a semi-colon? If it is a semi-colon, then try this...

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