View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich[_16_] Rich[_16_] is offline
external usenet poster
 
Posts: 22
Default truncate data on cell ?

I am using Excel 97.

I have a spreadsheet where there is a column that contains comments
typed in by the users. These comments can be a sentence long. The
comments tend to spill into the neighbor cells.

If I use the mid command, I chop of data. If I use word wrap, the
spreadsheet can look real ugly with very large cells.

Is there something that I can do other than word wrap that will stop
the data from spilling into the other cells?