If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is it possible to enter more than 255 characters in a cell
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 |
#2
|
|||
|
|||
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 "Dajana" wrote in message ... 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 |
#3
|
|||
|
|||
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.) Dajana wrote: 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 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is there a (non-binary) "if x then enter y" forumula? | Julie P. | Worksheet Functions | 9 | June 21st, 2005 08:49 PM |
Pressing the Enter Key | kbrad | Using Forms | 2 | February 23rd, 2005 12:13 PM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
International characters in mail merge | sandra | Mailmerge | 1 | December 23rd, 2004 05:42 AM |
Barcode scanning - need auto enter | Robert Pomon | Setting up and Configuration | 1 | May 7th, 2004 05:06 PM |