Number of characters in a cell

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?
 
F

Frank Kabel

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increasing # of Characters to display from a cell 6
check first 3 characters of a cell and compare to a table 4
How do I display more than 1,024 characters in Excel 2003? 2
Spell check / character cell limit 2
Why can't I get more than 255 characters in one cell in Excel 07? 1
Problem printing a large excel cell 5
Extra characters appear in the formula bar but not in the cell 1
Splitting cell contents into other columns 1

Top