How to stop Excel from truncating text to 255 characters?

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!
 
D

Dave Peterson

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
Make Table Query Truncating Memo Field at 255 Characters 2
VBA formula strings longer than 255 characters 3
Excel Data Truncated to 255 Characters 0
Mail Merge with Excel and Word 2007 1
worksheet.copy truncates at 255 characters 3
Why is Excel truncating my text to 255 characters? 2
RDBMerge Text limit 0

Top