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

Use a variable in a ShapeRange.Increment 0
Calculate days, months and weeks difrence 0
how do I set a maximum characters in a specific cell 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Force line break based on text 3
DOES EXCEL HAVE a MAXIMUM NUMBER OF COLUMNS PER WORKBOOK? 3
How to remove a combination of letters and special characters 2
Can't seem to delete all images from a Word Doc 2

Top