Hi,
Task at hand is to achieve this effect:
Short Company Name....................Meredith Rockefeller
Long Company Name Truncated If Nece.......Judy Short

Trival task in Word but how to do it programatically in Excel?
Components I think I need are calculations of printable width of cell
contents.
I then do my sums and take as much of Company Name and dots "........." to
fit a cell, given length of the Contact Name.

Other suggestions are warmly welcome :)
Paul