Adding Bullet Labels in a JOIN Function

Taylor Riley

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

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

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...

="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

Taylor Riley

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

Paul Newcome

Happy to help! 👍️