Adding Bullet Labels in a JOIN Function

Hi!

I have the Below Join function setup to summarize values from multiple cells. I would also like to add an Indicator of what information those values are representing.

=JOIN([Buy Now or Trial]1:[Other Information]1, SUBSTITUTE([New Line]$1, "-", ""))

Is it possible to add each cell as a bullet point?

"• Buy Now or Trial" [Buy Now or Trial]1:[Trial Duration]1

"• Offer Pricing" [Offer Pricing]1

"•Offer Details" [Offer Details]1

"•Promo Start Date" [Promo Start Date]1

"•Promo End Date" [Promo End Date]1

"•Other Information" [Other Information]1

Find more posts tagged with

Accepted answers

Paul Newcome

In that case you will need something more along the lines of...

="Buy Now/Trial: " + [Buy now or trial]@row + CHAR(10) + UNICHAR(10625) + "Offer Pricing: " + [Offer Pricing]@row + CHAR(10) + UNICHAR(10625) + "Offer Details: " + CHAR(10) + [Offer Details]@row + "Promo Start Date: " + [Promo Start Date]@row + CHAR(10) + UNICHAR(10625) + "Promo End Date: " + [Promo End Date]@row + CHAR(10) + UNICHAR(10625) + "Other Information: " + [Other Information]@row

All comments

Paul Newcome

Try this...

=JOIN([Buy Now or Trial]1:[Other Information]1, CHAR(10) + UNICHAR(10625))

CHAR(10) is the line break and UNICHAR(10625) is a bullet point.

Taylor Riley

@Paul Newcome,

That Returns:

Ideally, I would like it to look like:

Paul Newcome

In that case you will need something more along the lines of...

Taylor Riley

@Paul Newcome That worked! Thank you for your help!

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.