Text box length is limited to 255 chars

[anishms]

I have added a Text Box in my dash board with a link to one of the cell ($AM$25) having the texttojoin array formula.
I have linked it to a text box as i cant merge the cells with array formulas. but the text box is limited to 255 chars and not showing the complete text from cell $AM$25.
Is there any way to capture the complete text?


Cell AM25 =

Notes Table

 

[Logit]

https://support.microsoft.com/en-us...ror-4609-string-too-long-error-message-when-y

 

[Chihiro]

Or using method outline in the thread below.
https://chandoo.org/forum/threads/text-box-linked-to-cell-displays-cropped-text.33526/