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?