Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix - formatting multiple values

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 

 

  • 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

     

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    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

     

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    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