Merging variable length data to a table

[THE Burg]

I have a table set up in my main document and I'm merging data to it from and
Excel spreadsheet. The table is set to auto fit to conetents, Every thing
works fine for the first 9 records, where the "part number" field ends in 1
through 9. However when the 10th record (part numbers ending in 10 and
above) and up are merged, the last character is wrapped making the cell
taller instead of wider. I tried suggestion from Peter Jamison from
7/24/2008 and locked the row height. This simply kept the wrapped character
from showing -- now my part number ends in 1 instead of 10! I can widen and
lock the cell width as well I suppose, as a last resort, but I really would
like to be able to have the table resize as it does with normal data. Any
thoughts?

 

[macropod]

Hi Burg,

Ideally, the table should be formatted so that its layout will be the same for all merged records. For your problem cell, this could
be done by widening the column, and/or by reducing the internal cell margin. You could also try setting the 'fit text' property for
the cell but, whilst that might result in long strings being compressed to fit on one line, it can also result in short strings
being overly stretched.