Hello everyone

Can anyone tell me how many charectors can one cell in excel hold at the max??

Thanks for all your posts in advance

Quite a few, and probably limitless. Of course, that might give you a very long spreadsheet if you ever print it out. The Excel Help feature is very good. Give it a try.

I don't think there is a specific number of characters limit, but there is a limit to how many functions can be nested into one formula... seven. If you have a calculation that requires more than 7 things to figure out along the way (IF/THEN for instance), you'll have to break the logic up amongst two or more cells.

Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

Quote:

---

Originally Posted by mdosh01

Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

---

How on earth did you find that out... that's awesome info if correct! :)

... and as far as I'm concerned, 32k translates into "no meaningful limit"... I'm just saying.

He's only bloody right!

Go into Excel, go into help and type

Click on "Excel specifications and limits"

Expand "Worksheet and workbook"

And you'll see;

Quote:

---

Worksheet and workbook specifications

Feature Maximum limit
Open workbooks Limited by available memory and system resources
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Row height 409 points
Page breaks 1000 horizontal and vertical
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Sheets in a workbook Limited by available memory (default is 3 sheets)
Colors in a workbook 56
Cell styles in a workbook 4,000
Named views (view: A set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.) in a workbook Limited by available memory
Custom number formats Between 200 and 250, depending on the language version of Excel you have installed.
Names in a workbook Limited by available memory
Windows in a workbook Limited by system resources
Panes in a window 4
Linked sheets Limited by available memory
Scenarios (scenario: A named set of input values that you can substitute in a worksheet model.) Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario 32
Adjustable cells in Solver 200
Custom functions Limited by available memory
Zoom range 10 percent to 400 percent
Reports Limited by available memory
Sort references 3 in a single sort; unlimited when using sequential sorts
Undo levels 16
Fields in a data form 32
Custom toolbars in a workbook Limited by available memory
Custom toolbar buttons Limited by available memory

---

He's getting a green for that!

:) Thanks. It is interesting what you can find in Help sometimes. Unfortunately, usually not what I need!