How do I use the SUBSTITUTE formula if the text to be substituted contains a "
? For example, if I want to change Hello"Bye
to an empty string:
- Assume
Cell A1
:Hello"Bye
I have tried both
B1=SUBSTITUTE(A1,"Hello"Bye","")
and
B1=SUBSTITUTE(A1,""Hello"Bye"","")
Both result in an error because there is a "
in the middle of the text confused with the "
from the formula.
How can I fix this?