cell limits

S

shank

What is the character limits for individual cells?
Is it 256...?

I was contemplating generating a spreadsheet from a database. I'm guessing
that a memo field would get truncated... correct?

thanks
 
A

Andy B

shank

Go to Help, search for 'specification'

Cell content (text)
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

Andy.
 
L

Lila

-----Original Message-----
What is the character limits for individual cells?
Is it 256...?

I was contemplating generating a spreadsheet from a database. I'm guessing
that a memo field would get truncated... correct?

thanks

Worksheet size 65,536 rows by 256 columns
Click to expand...
Column width 255 characters
Row height 409 points
Length of cell contents (text) 32,767 characters. Only
1,024 display in a cell; all 32,767 display in the formula
bar.
 
Top