Insert hard returns in Excel measures formula

bartmac

New Member
Joined
Feb 25, 2025
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
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
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top