Hi I have a dynamic text box to display the results of a formula in a cell. The formula is returning a string of text from an array. This result shows fine in the cell containing the formula but in the text box which is equal to this cell the text is truncated to 255 characters.
For example cell J12 is the formula that returns the string of text longer than 255chars. Text box =J12 is truncating.
How do I get around this?