How to use SUBSTITUTE if the text contains " inside You can escape " by doubling it: SUBSTITUTE(A1,"Hello""Bye","")