either do it as ajm said or this
where A1 has your initial wording. (the formula above will remove all instances of " within that text (its more complex as excel read "" as text so """ wouldn't subsitute " hence the reasoning behind CHAR(34) which is the charicter code for "![]()
=SUBSTITUTE($A1,CHAR(34),"")
Bookmarks