Number of characters in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I read that excel will allow 32,767 characters per cell, but it will only
display 1,024 of them in the cell itself but all of it can be seen in the
formula bar.

I did a copy/paste into a new workbook but when I opened the workbook the
next time the text in the cell has been 'clipped' to about 260 characters.
This is also the case in the formula bar where it has also been reduced. Is
there something that I have to do in order to keep the data?
 
Hi
1. For displaying more charatcers in one cell you may insert manual
linebreaks with ALT+ENTEr every 1000 characters

2. AFAIK you can't do anything against this if you copy a complete
sheet to a new workbook.
 
It was truncated at 255 characters.

If you get that message, just go back to the original sheet.
ctrl-A (twice in xl2003)
edit|copy

back to the copied sheet
and paste over A1.

Copying the worksheet keeps all the nice stuff--headers/footers/margins/filters
and copying the cells gets those long strings back.
 
Back
Top