Go ahead and wrap text, but then reset the height of the row back to
regular height. It will then display as much as it can in the single
cell..and then not display the rest (but will show up in the formula
bar when selected).


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=483873