I have a formula that dumps a variable amount of text into a cell. Sometimes there is too much text in the cell for it to display properly (at the font size I need), and I was wondering if there was a way to get it to dump the rest of the text (that doesn't fit) into a second cell on a different sheet, sort of like a "Continued from page one" situation.

This is the same concept as linked text boxes (in MS Publisher, InDesign, and other programs), where the text from one box flows into the second.

Is there a way to do this?

Thanks.