Excel Formula using substitute function to replace quotation marks
=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.