Excel Formula using substitute function to replace quotation marks Substitute formula is substitute(cell to focus on, text to replace, text that replaces it). 2nd and 3rd inputs need to be in quotations it seems to get the function to work.

So how would you substitute a single quotation mark in a cell.

None of the following work:

=substitute(A1,""","%22C")
=substitute(A1,&amp;char(32), "%22C")
=substitute(A1,"&amp;char(32)","%22C")
=substitute(A1,"\"","%22C")


Any ideas?
=SUBSTITUTE(A1,CHAR(34),"%22C")




&amp; is for concatenation, but you're not concatenating, so it should be omitted.
CHAR(34), not 32, is the double quote character.