Cutting off data in a cell

[pjscott]

I have some users who have created a form using Excel. They have merged 16
columns to create a cell for text. They have almost 1900 characters and
spaces in this cell.

The problem their having is the data is being cut off on the right side.
When you double click within the cell all the data appears in the cell but
when you click out of the cell the data cuts off again.

I've tried everything I can think of so does anyone know of a way to get all
the text to display in the cell?

Thank for the help,

Paul

 

[muddan madhu]

select the cell, right click format cells | allignment tab | check
wrap text | ok
increase the row height.

 

[Dave Peterson]

Excel's help says that you can see about 1024 characters in the cell. But if
you add alt-enters (to force new lines within the cell) every 80-100 characters,
you can see lots more.

But you may have to adjust the rowheight manually. Merged cells can be a pain.

 

[Gord Dibben]

Add a linefeed every 100 characters using Alt + Enter


Gord Dibben MS Excel MVP