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

Options

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?

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!