Cell truncated to 256 characters during copy to new worksheet

[Brad Backlin]

When you copy a cell which has greater than 256 characters
from one worksheet to another the cell gets truncated to
256 characters. I have used the workaround suggested in
the MS knowledge base. Does anyone else have any ideas?

Brad

 

[Dave Peterson]

Was the suggestion in the KB to copy the worksheet, then come back and copy the
cells, then paste the cells?

If it was, then I don't have another suggestion. If it wasn't, then I do.

 

[Brad Backlin]

The suggestion was to do a select all. Copy the selected
cells and then paste to the new sheet.

Your suggestion is to copy the worksheet and then come
back and copy the cells?

Brad

 

[Dave Peterson]

yep.

If you copy the worksheet as a whole, then you get all the formatting, page
setup, etc. (but with possible truncation).

Then if you come back and copy the cells, you can get fix the truncated cells.