I'm having trouble creating a Formula field that joins two text fields together when the user text contains double quotes.
For example I have two fields named as follows to hold sizes in feet and inches noted with single and double quotes.
Length (Feet & Inches) = 50'6"
Width (Feet & Inches) = 20'0"
I then merge them together with the following formula expression.
Concat(Tostring(${Leads.Length (Feet & Inches)}),Tostring(' x '),Tostring(${Leads.Width (Feet & Inches)}))
The result is blank. I assume it's because the system is interpreting the double quotes as a formula instruction rather than taking it as text.
How can I make the formula expression ignore the double quote and accept it as just another text character?
Thank you.