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?

Find more posts tagged with

Formulas

Accepted answers

TVang

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.

All comments

TVang

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.