How to use quotation marks in formulas?

#1

Hi!

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?

#2

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

3 Likes
#3

Thank you so much @JOHN_WORSHAM!