Is it possible to enter more than 255 characters in a cell

G

Guest

Is it possible to have more than 255 characters in a cell. I know that the
limit is 1024 but I want to be able to see and print all of the characters.

Thanks
Dajana
 
P

Paul B

Dajana, I think it will work if you manually enter some line breaks in the
text with ALT+Enter
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
D

Dave Peterson

The limit is 32767, actually.

But you'll only see about 1000 characters unless you add alt-enters (to force a
new line within the cell) every 80-100 characters.

(Well, xl95 does have a limit of 255 characters per cell, but xl97 increased it
to 32767.)
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I get more than 255 characters into a cell? 3
Why can't I get more than 255 characters in one cell in Excel 07? 1
Number of characters in a cell (one row, merged columns) 1
How can I copy more than 255 characters in a cell without truncati 1
Word wrap with > 255 characters 2
Microsoft Excel Cell text limits 3
How do I copy more than 255 characters per cell? 2

Top