maximum number of characters

M

Mike

I found in the Microsoft Knowledgebase a statement that
says the maximum number of characters that can be in any
one cell is 32767 (2^15 - 1). I can't find a reference but
it seems that only 1024 (2^10) will display or print. Is
there any way to increase this (the number of characters a
cell will display or print)?

Thanks,
Mike
 
M

Mark

Excel 2000 Help (Search for Limit)

Length of cell contents (text) 32,767 characters.

Only 1,024 display in a cell; all 32,767 display in the
formula bar.
 
G

Gord Dibben

Mike

Excel Help states that "a cell can contain 32,767 characters but only 1024
will be visible or can be printed."

If you set the cell to wrap-text and place some ALT + ENTERS after every few
hundred characters you can get some more characters in the cell.

Before you take Help or my suggestion literally you may find some
enlightenment regarding the limitations of text in a cell in this google
search result.

http://snurl.com/26vl

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Maximum number of characters a cell can contain? 1
how do I set a maximum characters in a specific cell 2
Number of characters in a cell (one row, merged columns) 1
Can I restrict a text column to a specific number of characters? 4
How can the number of words per cell in Excel be increased? 8
# of Characters/cell 2
Maximum Characters in a cell 1
Max number if characters in a merged cell 1

Top