"\" Character in String

Andi Hawes
Andi Hawes ✭✭
edited 12/09/19 in Formulas and Functions


Id like to create a formula that mirrors 'Concatenate' from Excel, so Id like 3 items concatenated; 2 sources from 2 columns on my sheet and the third is a manually written in text string with the formula itself:

Column A

Tet String abc\123 [as an example]

Column B

I can use "+" or JOIN it seems, but the fact my text string part of the formula has a "\" seems to throw the formula creation and doesnt allow it? Or if it does, the "\" is auto removed.

Any ideas why? Work around?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!