Forum Discussion
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-msftMicrosoft 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-msftMicrosoft 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