Using " as text in formula

I am trying to use the text " in a formula but it keeps reading it as the formula quotations. Is ther any way to use " in text in a formula.

For example so that it would read 3’’ x 4’’
Concatenate([Unit Price Calculator].Width," " “,[Unit Price Calculator].height,” " ")


You can use the backslash (\) character by placing it before a special character so that character is interpreted as plain text. in your example it would look like so:

Concatenate([Unit Price Calculator].Width, "\" x ", [Unit Price Calculator].height,"\"")
1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.