[Solved] How do I enclose a double quotation mark in formula

[HowdeeDoodee]

Edited several times.

This is what I am referring to as a double quotation mark "

I have two formulas. Formula A finds a single apostrophe and counts the number of occurances in the cell F1. This formula works.

However formula B brings up an error message because I am enclosing a double quotation mark inside double quotation marks. How do I express the quotation mark in formula B and find the number of double quotation marks in cell F1?

A.
=(LEN(F1)-LEN(SUBSTITUTE(F1,"'","")))/LEN("'")

B.
=(LEN(F1)-LEN(SUBSTITUTE(F1, ""","")))/LEN(""")

 

[fridgenep]

Hi,

okay... :wink:

Why do you use the last term?

/LEN(""")

I think it´s nonessential, but I´m a amateur.

 

[Aladin Akyurek]

Hi,

okay... :wink:

Why do you use the last term?

/LEN(""")

I think it´s nonessential, but I´m a amateur.

Is that not something what I already stated?

 

[fridgenep]

Hi Aladin Akyurek,

sorry...

Please forget my stupid "question". I have to find my glasses...