Forum Discussion
Pivot Table truncation of original text
Hi, I have a budget vs actual table that includes an original budget note for each line item. The note describes what work or expense was intended. The note on a particular line item can be lengthy. ...
Two thoughts:
- have managers use a), b), c) instead of 1), 2), 3)
- create a "helper column" in which you truncate or eliminate that leading 1) and use that helper column in the Pivot Table data.
A third thought: it sometimes is possible to create the semblance of a Pivot Table using some of the Dynamic Array functions as a work-around. That might work, although I'll grant you that the simplicity and ease of "letting Excel do all the work" in the Pivot Table is very attractive.
Thanks, I can just have them not list their priorities with numbers. I did not realize that Excel would treat the field as a numerical field and truncate it to 255 characters. While not positive that is what is happening that is what I assume is happening based on the results. Thanks for responding and for offering some alternatives.