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