How to use quotation marks in formulas?


I want to use the SPLIT function on some text, and I want to split it at each "

Only problem: It breaks the function. It can’t accept: SPLIT(pageVars.the_text_to_split,""")

Is there a way to mark up the " so that it can be used in SPLIT, REPLACE_ALL and other formulas?

I think you put a backslash in front like this " \ " " (without the spaces)


Thank you so much @JOHN_WORSHAM!