Excel cell size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am exporting a file to excel and running into errors. I have determined
that it is one particular field that I am exporting that is causing the
trouble. Is there a limit on characters that a single excel cell can
contain, and is this different for exported files, and are there some
characters that excel cell's done like, or would cause trouble?

Thanks
 
Spencer-

Here are the cell size specifications found in Excel Help under "Excel
Specifications and Limits":

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

Why Excel is designed to allow 32K characters to be stored in a cell but
only display 1024 on a worksheet is a mystery to me. The only way to see all
of a string longer than 1024 characters in the the formula bar.

-Stan Shoemaker
Palo Alto, CA
 
You must log in or register to reply here.

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

How to Export Gmail Emails to PST Format? 6
Cell.Text different from Cell.Value when dates are concerned... 3
Excel 2011 Mac - Import Worksheets into a Single File 0
Using SumIF with an array 3
cell data 11
Macro that will insert a simple text string in top cell of text file 1
Copying jpeg image data date into excel 0
Identify when Excel is displaying ### in a cell? (contents>width) 1

Back
Top