How to stop Excel from truncating text to 255 characters?

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

Guest

I have a problem in using Excel to generate reports using text cells.
It accepts text longer than 255 characters but when I copy it or try to
report it in a pivot table the text is always truncated.
Can this be fixed?
I am using Office 2003 (11.6355.6408) SP1

Also I find that even when the Select button is pushed in, my pivot tables
keep losing their formatting.

Help!
 
No.

Maybe you could use some kind of key value and then use =vlookup() to return
that longer string based on the key. (Might not be useful if you actually pivot
your table!)
 

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
Copying text from text box 3
worksheet.copy truncates at 255 characters 3
Make Table Query Truncating Memo Field at 255 Characters 2
Excel Data Truncated to 255 Characters 0
Worksheet.Copy() truncates cell contents problem 3
Mail Merge with Excel and Word 2007 1
How to find row with more than 255 characters in a cell 4

Back
Top