Pivot table cutting information of a part of the information

  • Thread starter Thread starter ASR
  • Start date Start date
A

ASR

I have an exile file were one of the columns is a write up that needs to be
filled up by the users..This can sometimes go lebgthy upto say 9 to 10
lines...I have notices that excel is cutting off at one stage and putting a
square symbol..on some entries...Other entries are cutoff without that
symbol...however the smaller entries do update...Please help...

Regards
Anitha
 
First, those square symbols are probably linefeeds--alt-enters in the cells that
tell excel where to create new lines within the cell.

You can format that cell (range of cells) to allow wrap text and the squares
will disappear.

If your strings in your table are longer than 255 characters (or is it 256???),
then your string will be chopped. That's the way excel works.

(Maybe you can add a column with a shorter description and use that in your
pivottable. Then you can include any important information that was in the part
that got truncated.)

If your strings aren't that long, then make sure you increase the rowheight (or
columnwidth) to show all the string--or use a smaller font.
 
Back
Top