Hi All

I need to limit the amount of characters in a cell to 45 maximum.

If the cell is found to be over the 45 then the cell contents would be
foreshortened automatically.

Does any one know a formula to effect this?


Best Wishes

Drno