Can JOIN include a space as part of the end result?


After JOINing a series of cells, I need to include a space after "CSANe" but it keeps getting ignored.

Certificate No. column is the JOINed result

Cert # Preface is a formula. I tried ="CSANe "

I tried adding the Spacer column with the formula =" "

The space is always ignored.

Is there any way to get the space to appear?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!