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

Hi, Pam.
Smartsheet automatically trims white spaces. The function below forces a white space.
=[Cert # Preface]@row + " " + JOIN([YY]@row:[4 digits]@row)

Thank you, so much @TFC !
That worked perfectly.
Answers

Hi, Pam.
Smartsheet automatically trims white spaces. The function below forces a white space.
=[Cert # Preface]@row + " " + JOIN([YY]@row:[4 digits]@row)

Thank you, so much @TFC !
That worked perfectly.
Help Article Resources
Categories
Check out the Formula Handbook template!