Insert hard returns in Excel measures formula

[bartmac]

Hello, I created an Xcel pivot table and then created a measure to show text rather than numbers.
That is working fine with the following measure =CONCATENATEX(Goals,[Item]," ● ")
The result of this formula is text that appears in a cell like this
Item 1 ●Item 2 ● Item 3 ●Item 4 (and so on- the text wraps around)
I'd like to have the text appear in the cell as
●Item 1
●Item 2
●Item 3
●Item 4
with a hard break between each bulleted item.
I have not found a way to insert a return code -- and it does not appear that this is supported in the measures functions part of Excel
Any help appreciated ..

bartmac

 

[jkpieterse]

Can't you add an alt+Enter (alt+010 on your numeric pad on your keyboard)?

 

[bartmac]

To clarify, I am looking for how to enhance the following expression =CONCATENATEX(Goals,[Item]," ● ") to include some function or code to cause a hard return to follow each item in the text that is generated by the Pivot table using measures.