When concatenating text into a Long Text column, is it possible to add carriage returns?
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])
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |