Is there a character maximum per cell

S

soconfused

I was wondering if there is a maximum number of characters you can have in a
cell?
 
R

Ron Rosenfeld

I was wondering if there is a maximum number of characters you can have in a
cell?
Click to expand...

Yes there is, and it may be different in different versions.

Check HELP for Specifications and Limits.
--ron
 
D

DILipandey

Hi Soconfused,

Just checked.. in excel 2003 you can enter "32767" characters in a cell.
Thanks,
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
D

Dave Peterson

You can see more than the 1000 or so characters documented in xl's help by
adding alt-enters (to force new lines within the cell) every 80-100 characters.
 

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

Force line break based on text 3
how do I set a maximum characters in a specific cell 2
Set max characters in cell (Excel 2007) 4
Is there maximum number of characters per cell? 5
number of characters in each cell 5
DOES EXCEL HAVE a MAXIMUM NUMBER OF COLUMNS PER WORKBOOK? 3
How can the number of words per cell in Excel be increased? 8
Excel 2003 - Maximum number of characters a cell can contain? 1

Top