"\" Character in String

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

Forum



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?

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!