shankar
08-16-2009, 10:21 AM
Hi,
When a text is longer than the width of a cell, there are two options- one is to allow it to spill into the nearby cell(s), or wrap around so that the height of the cell increases. Is there a way to just truncate the string so that neither occur? I believe this option was there in earlier versions of Excel. I am using Office 2007. Thanks.
Shankar
When a text is longer than the width of a cell, there are two options- one is to allow it to spill into the nearby cell(s), or wrap around so that the height of the cell increases. Is there a way to just truncate the string so that neither occur? I believe this option was there in earlier versions of Excel. I am using Office 2007. Thanks.
Shankar