How to remove last character in a concatenation


I have a series of columns concatenated, separated by _ (so it looks like "A_B_C_D_E_...")

Some all columns after E are optional.

The end result means some concatenations end in "_"

I think a helper column might be needed, in which case the formula would be something like that solves for 'if row ends in "_", remove "_" - but I can't seem to get it to work.

Anyone know how to solve this seemingly simple need? Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!