I have a peculiar problem I can not seem to solve anyway I tried.

I need to write the values of 2 fields into an Excel 2003 cell separated by
a comma.
For example, €œSome text from field1,value of field2€�

The value of 2nd field is at the end and absolutely has to be displayed.
The value of 1st field can be truncated but the goal is to display as much
as possible.

The problem is some letters of some fonts can have larger width. For
instance, letter W takes up more space than letter i.
This makes it difficult to just assume the total length of a cell and do
simple truncating.

What are my options? Is there a way to intercept some sort of a cell
wrapping event?

Many thanks in advance,

--Mike