Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
remove last three characters of cell | Excel Discussion (Misc queries) | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
Is there a (non-binary) "if x then enter y" forumula? | Excel Worksheet Functions |