quotes in formulas using vba

[Doug Broad]

I want to enter the following formula into cell a5

=SUBSTITUTE(F3," ","")

I tried this:

range("a5").value= "=substitute(f3,""" ""","""""")"

I get an error when I try to do this
Expected end of statement

I get lost in the quotes. What is the process of translation?

Thanks

 

[Laura Cook]

You have too many quotes, try the following:

Range("A5").Value = "=SUBSTITUTE(F3,"" "","""")"

 

[Doug Broad]

Thanks Laura!
That worked. So does the outer pair of quotes
for each quoted section allow the inner set to show
up?