excel limitation

  • Thread starter Thread starter inungh
  • Start date Start date
I

inungh

I have a spreadsheet which get data from my MS Access memo field.

It happens the memo filed is longer than 1024 characters which Excel
only put the first 1024 characters. We are unable to print the whole
contents.

I tried to enter an enter have them in two paragraph, but it still has
1024 characters only.

Are there any workaround for this?

Your help is great appreciated,
 
hi
in xl help, type the word specifications. this will display the specs and
limit of your version of excel.
length of cell content- 32767 characters. only 1024 show in a cell. the rest
show in the fomula bar.
no way around this. it's an excel ceiling.

Regards
FSt1
 
If you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll be able to see and print more than the 1000 (or so)
documented.
 

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

MS Query Cell Limit 2
Real-time character counter 14
Dropping Data When Copying 2
Can I trap "formula too long"?? 3
Beyond 1024 cell content limit 6
Access Memo field to Excel Textbox 1
Excel text export limit - 1024 per line (not cell), workaround? 11
Copying cell text to clipboard (using Putinclipboard) 2

Back
Top