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,"\"")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.