Referencing Multi-Select Dropdown in a Formula to Get Elements On One Line

Hey everyone,

By default, if you a cell in a multi-select dropdown column with more than one option selected and then copy/paste that cell or reference it in a formula, each element is pasted on a separate line, like this:

Is it possible to get all the elements on one line with commas, like this?

Thanks!

Find more posts tagged with

Sheets

Formulas

functionality

Accepted answers

Paul Newcome

Yes. Try something like this...

=SUBSTITUTE([Multi Select Column]@row, CHAR(10), ", ")

CHAR(10) (line break) is the delimiter used by default in multi-select columns, so we use the SUBSTITUTE function to replace that with the "comma space" delimiter that you wanted.

All comments

Paul Newcome

Yes. Try something like this...

=SUBSTITUTE([Multi Select Column]@row, CHAR(10), ", ")

CHAR(10) (line break) is the delimiter used by default in multi-select columns, so we use the SUBSTITUTE function to replace that with the "comma space" delimiter that you wanted.

SoS | Dan Palenchar

Worked like a charm, thanks much Paul!

Paul Newcome

Happy to help! 👍️

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.