Hello, I am using the following formula in a Pivot Table =CONCATENATEX(Range,[Priorities]," • ") so that I can display text values.

I end up with values in a cell that look like this

Some priority • Another priority • A third priority, • etc

The above text wraps in the cell and is working exactly as it is supposed to work. However, I am wondering if there is some modification I can make to the formula to have the text display in the cell as

• Some priority
• Another priority
• A third priority

The number of text items will vary between none and 12 lines of text.