Missing text in a cell?
 

How do I show all the text in a cell? I have tried the auto-fit options for
both row and column and the wrap alignment option and it still not showing
all the text I have typed. It didn't do it in short paragraphs but with the
longer ones--the last 2-3 sentences are missing.

Missing text in a cell?
 

Joyce

Excel will only display the first 256 characters ina cell, up to 32,000 or
something similar can be displayed in the formula bar. (To check this look
up excel limits in help, sorry I only have a beta on this machine with no
help files)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Joyce" wrote in message
...
How do I show all the text in a cell? I have tried the auto-fit options
for
both row and column and the wrap alignment option and it still not showing
all the text I have typed. It didn't do it in short paragraphs but with
the
longer ones--the last 2-3 sentences are missing.

Missing text in a cell?
 

Thanks...

Can I change or adjust that limit..? does it count spaces too?
I find it really odd..I'll check my other spreahsheets and see if they went
over the 256 characters..

"Nick Hodge" wrote:

Joyce

Excel will only display the first 256 characters ina cell, up to 32,000 or
something similar can be displayed in the formula bar. (To check this look
up excel limits in help, sorry I only have a beta on this machine with no
help files)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Joyce" wrote in message
...
How do I show all the text in a cell? I have tried the auto-fit options
for
both row and column and the wrap alignment option and it still not showing
all the text I have typed. It didn't do it in short paragraphs but with
the
longer ones--the last 2-3 sentences are missing.

Missing text in a cell?
 

Excel's help says that it'll display 1024 characters (all 32767 will appear in
the formula bar).

Joyce, if you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll see far more than the 1024 limit that excel's help gives.

Nick Hodge wrote:

Joyce

Excel will only display the first 256 characters ina cell, up to 32,000 or
something similar can be displayed in the formula bar. (To check this look
up excel limits in help, sorry I only have a beta on this machine with no
help files)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS

"Joyce" wrote in message
...
How do I show all the text in a cell? I have tried the auto-fit options
for
both row and column and the wrap alignment option and it still not showing
all the text I have typed. It didn't do it in short paragraphs but with
the
longer ones--the last 2-3 sentences are missing.

--

Dave Peterson

Missing text in a cell?
 

correction: 256-32000 characters in a cell?
i have less than 32000 characters for sure...is there anything else that i
should do? or might have forgotten?

"Nick Hodge" wrote:

Joyce

Excel will only display the first 256 characters ina cell, up to 32,000 or
something similar can be displayed in the formula bar. (To check this look
up excel limits in help, sorry I only have a beta on this machine with no
help files)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Joyce" wrote in message
...
How do I show all the text in a cell? I have tried the auto-fit options
for
both row and column and the wrap alignment option and it still not showing
all the text I have typed. It didn't do it in short paragraphs but with
the
longer ones--the last 2-3 sentences are missing.