Excel 2000

[Raymond]

We have a situation where all of the text keyed into a
cell does not appear when viewing or printing the
spreadsheet. If the user merged a row into columns from J
through W, it all appeared. If we inserted hard returns
into the entry into the cell, it also displayed. Has
anyone had similar a experience? If so how did you
resolve it?

Thank you.

 

[Gord Dibben]

Raymond

Specs for Excel states that 32,767 characters can be placed in a cell.

1024 will be visible or can be printed.

Using ALT + ENTER to get hard returns will increase this limit.

Gord Dibben Excel MVP

 

[Raymond]

Gordon,

Thank you so much for this valuable lesson!

Raymond