truncate data on cell ?

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

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?
 
Enter a space(via spacebar) in each of the adjacent cells.

Actually, enter it in top cell then drag/copy down.

Try not to forget you have a space in these cells.

Gord Dibben XL2002
 
Back
Top