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

Pam Grant

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?

Toufong Vang

Hi, Pam.

Smartsheet automatically trims white spaces. The function below forces a white space.

=[Cert # Preface]@row + " " + JOIN([YY]@row:[4 digits]@row)

Pam Grant

Thank you, so much @TFC !

That worked perfectly.

Toufong Vang

Hi, Pam.

Smartsheet automatically trims white spaces. The function below forces a white space.

=[Cert # Preface]@row + " " + JOIN([YY]@row:[4 digits]@row)

Pam Grant

Thank you, so much @TFC !

That worked perfectly.