| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop Excel from truncating text to 255 characters?
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to stop Excel from truncating text to 255 characters?
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!) katep wrote: 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! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is Excel truncating my text to 255 characters? | Excel Discussion (Misc queries) | |||
| How to stop Excel from automatically truncating leading zeros | Excel Discussion (Misc queries) | |||
| Intentionally truncating text characters | Excel Discussion (Misc queries) | |||
| truncating a colum to 55 characters | Excel Discussion (Misc queries) | |||
| truncating pasted text after 250 characters | Excel Programming | |||
Linear Mode
