When concatenating text into a Long Text colu...

When concatenating text into a Long Text column, is it possible to add carriage returns?

0 3 388
3 REPLIES 3

Would you please show an example, thanks.

So the long text would display something like " Option 1 = ยฃ1000 Option 2 = ยฃ2000 Option 3 = ยฃ3000 "

Soโ€ฆ Iโ€™m assuming something like this exists:

Concatenate( "Option 1 = ",[ColumnA],, "Option 1 = ",[ColumnB],, "Option 3 = ",[ColumnC], )

I can do the concatenate bit easily, but Iโ€™ve not seen anywhere you can force a .

Whereas you can do this if typing it in.

The idea behind it is that its a way to display data in a kind of table.

Where each option might have 3 different prices and I donโ€™t want the user to have to scroll up and down.

Concatenate( "Option 1 = โ€œ,[ColumnA],โ€

","Option 1 = โ€œ,[ColumnB],โ€

","Option 3 = ",[ColumnC])

Top Labels in this Space