I have about a hundred worksheets that I am applying this to:
In each worksheet I am referrencing text from the first worksheet, and in
many instances the text is too long for one cell. The text will be placed in
an area that is two cells wide by 5 or 6 high. Without merging the two cell
together and wrapping the text and extending the cell taller, I want to place
watever text does not fit in the first row into the next row, without
breaking apart words. Is this possible?