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