Displaying Large Amount of Data in a Cell

R

Racer57

Exporting an Access table to excel - one of the fields is a memo filed that
has a large amount of text in it.
Two questions:
1. What is the limit on the amount of characters that a cell can hold?
and
2. How can I view that text in the Excel field it was exported to?

--
Paul Mazzola
General Manager-High Speed Data Services
Time Warner Cable
Eastern Carolina Division
Wilmington NC
Ph: 910-772-5793
Fax: 910-772-5796
 
J

jeff

Hi,

1. A cell can only display 1024 characters in a cell.
2. I'm not sure there's a way to get to the rest...
Any way you can export to a text file and break it
up (with a carriage return) ? so the overflow will
go into additional rows??

jeff
 
D

Dave Peterson

A cell in xl will hold about 32k (look at "Excel specifications and limits" in
xl's help).

Left to its own devices, xl will show you about 1000 characters in the cell (all
32k will appear in the formula bar).

But you can add alt-enters to the cell's value and see lots more.

I don't use access, so I'm not sure if the way you import into excel will have
any effect on any of this.
 

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

Top