N
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
How many characters/words
Thanx.
NED 1451
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
the max is 1,024 characters. You can extend this limit by entering
manual linebreaks withj aLT+ENTER
the max is 1,024 characters. You can extend this limit by entering
manual linebreaks withj aLT+ENTER
G
Gord Dibben
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
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
C
ChaimB
Is this true for EXCEL 2000?
I have a file from a customer which currently has 1022 characters in
one particular cell and I have NOT been able to enter any additional
characters - I did try issuing ALT-ENTER but this does not seem to do
anything.
I have noticed that in EXCEL 2003 I CAN enter many more characters!
For my own edification, what dose the 32 KB limit give me if
operationally I can enter only 1 KB+ number of characters?
Thanks,
Chaim
I have a file from a customer which currently has 1022 characters in
one particular cell and I have NOT been able to enter any additional
characters - I did try issuing ALT-ENTER but this does not seem to do
anything.
I have noticed that in EXCEL 2003 I CAN enter many more characters!
For my own edification, what dose the 32 KB limit give me if
operationally I can enter only 1 KB+ number of characters?
Thanks,
Chaim
G
Gord Dibben
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
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
What happens when your customer tries to enter the 1023rd character?
Maybe he or she is just not seeing them.
Maybe he or she is just not seeing them.
C
ChaimB
Basically, nothing happens! The cursor does NOT move at all, and there
is a "BEEP".
For "debugging" purposes I set a LEN function on this cell in another
empty cell and the size remains the same/
Thanks,
Chaim
is a "BEEP".
For "debugging" purposes I set a LEN function on this cell in another
empty cell and the size remains the same/
Thanks,
Chaim
D
Dave Peterson
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?
If you put
=REPT("asdf ",250)
in A1 and then Edit|copy, Edit|paste special|Values
Can you add more text to that cell?