How to add " as a character to Substitute function

[Zivhodiva]

Hi,
I am trying to run a simple Substitute
Substitute this: <p>
with this: <p dir="ltr" style="text-align: left;">

Excel doesn't accept it as is, I assume it's because the Substitute text has " as part of it.

I've tried:
=SUBSTITUTE(A2,"<p>",<p dir="ltr" style="text-align: left;">)
=SUBSTITUTE(O2,"<p>","<p dir="ltr" style="text-align: left;">")

Any idea for a workaround?

thanks

[MarvinP]

Hi Zivhodiva,

If you have a quote in the replace string, make the (") a double quote ("") and see what happens.
https://stackoverflow.com/questions/...titute-formula

[Zivhodiva]

Works!!

Thanks MarvinP