Cell truncated to 256 characters during copy to new worksheet

  • Thread starter Thread starter Brad Backlin
  • Start date Start date
B

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
 
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.
 
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
 
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.
 
Back
Top