Matrix - formatting multiple values

[Anonymous]

Hi all,

I have a matrix with multiple values like this:

Cell(1,1) = value1, value2, value3, value4, value5

Cell(1,2) = value6, value7, value8, value9

I am wondering if it is possible to format the matrix to have the cells show like this:

Cell(1,1) = value1, value2,

                 value3, value4 

                 value5

Cell(1,2) = value6, value7,

                 value8, value9 

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you could use the UNICHAR(10) function to return a line break in the matrix visual:

But you could not define the numbers of characters in a cell, due to the changes will apply in the whole column.

Hope it could help you.

Regards,

Daniel He