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?

Perhaps https://support.microsoft.com/en-us/kb/213841

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post