Maintain delimiters in a join() column when exporting to excel.

Hello, we have a bunch of columns with multiple selection dropdowns. When I export to excel the selections are concatenated without spaces:

I tried to create a helper column using JOIN():

which mostly works, although it only ever shows a space between the text, and not the delimiter. However, on export to excel the helper column is still concatenating all the text without any space. I've looked at other questions which is how I found JOIN(), but they all seem to be doing far more complex things. This seems like it ought to be simple?

Find more posts tagged with

Accepted answers

jjg279

You need to wrap your join in a substitute and replace CHAR(10) with " ;"

Formula:

=SUBSTITUTE(JOIN(Name1, ""), CHAR(10), "; ")

All comments

jjg279

You need to wrap your join in a substitute and replace CHAR(10) with " ;"

Formula:

=SUBSTITUTE(JOIN(Name1, ""), CHAR(10), "; ")

drew.tyre

Yep! That did the trick, thank you.

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.