I am using a Google form to capture information and insert it onto an Excel spreadsheet. One of the fields has the potential to exceed one page (the ultimate document will be printed). Is there a way for Excel to recognize that the text exceeds the size of the cell (on page 1) and therefore truncate the data in that cell, and then placing the remainder of the text into another cell (on page 2)?
There will be static information above and below the cells in question, so allowing the text to just flow onto another page is not workable. I've also tried the truncate (LEFT/RIGHT) formula, but it is too rigid - not taking into account whole words or any spaces between paragraphs.
Bookmarks