G Guest Nov 3, 2004 #1 Can anyone give me some info on the maximum text size you can put in a cell. How many characters/words Thanx. NED 1451
Can anyone give me some info on the maximum text size you can put in a cell. How many characters/words Thanx. NED 1451
F Frank Kabel Nov 3, 2004 #2 Hi the max is 1,024 characters. You can extend this limit by entering manual linebreaks withj aLT+ENTER
Hi the max is 1,024 characters. You can extend this limit by entering manual linebreaks withj aLT+ENTER
G Gord Dibben Nov 3, 2004 #3 Ned The maximum is 32,767 characters to a cell. However, as Frank points out, only 1024 will show or can be printed. Increase the 1024 by using ALT + ENTER at appropriate spots. Gord Dibben Excel MVP On Wed, 3 Nov 2004 00:49:04 -0800, "NED 1451" <NED
Ned The maximum is 32,767 characters to a cell. However, as Frank points out, only 1024 will show or can be printed. Increase the 1024 by using ALT + ENTER at appropriate spots. Gord Dibben Excel MVP On Wed, 3 Nov 2004 00:49:04 -0800, "NED 1451" <NED
G Gord Dibben Feb 17, 2005 #4 Chaim I have never used 2000 so can't speak for that. 97 shows a portion of the characters. As you decrease the number of chars, the shown portion decreases in some sort of ratio. As far as being able to enter 32,767 chars and see only 1024, your guess is as good as mine. Gord Dibben Excel MVP
Chaim I have never used 2000 so can't speak for that. 97 shows a portion of the characters. As you decrease the number of chars, the shown portion decreases in some sort of ratio. As far as being able to enter 32,767 chars and see only 1024, your guess is as good as mine. Gord Dibben Excel MVP
D Dave Peterson Feb 18, 2005 #5 What happens when your customer tries to enter the 1023rd character? Maybe he or she is just not seeing them.
What happens when your customer tries to enter the 1023rd character? Maybe he or she is just not seeing them.
D Dave Peterson Feb 20, 2005 #6 I don't have a guess what could be happening? If you put =REPT("asdf ",250) in A1 and then Edit|copy, Edit|paste special|Values Can you add more text to that cell?
I don't have a guess what could be happening? If you put =REPT("asdf ",250) in A1 and then Edit|copy, Edit|paste special|Values Can you add more text to that cell?
