I sometimes use merged cells to display concatenated info. After about 1100
characters, the cells won't display the remaining text no matter how heigh
the rows or wide the colums.

Question #1 Is there a way to set the cell limits for how many characters
can be displayes?

Question #2 In the above senario the merged cells that contain the
concatenate instructions will not automatically adjust the row heighth for
the content even thought the wrap text function is turned on. Is there a way
to do this?