cell limits

  • Thread starter Thread starter shank
  • Start date Start date
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
 
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.
 
-----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.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
mailmerge maximum field size 2
can i extend the default limit of 256 bytes on memo fields? 1
256 character limit in pivot tables 1
No. of characters in an Excel column 2
printing limitation 1
How to limit cell to 30 characters or less 2
How do I increase viewable cell character count limit in Excel? 2

Back
Top