Hi All

In XL2002, I'd like to be able to apply dot trailers to a cell if the text
in the cell is too long to fit with the current column width - much the same
as it does in Windows Explorer.

e.g.
If the text in the cell read: "This is text in the cell but it's too long"
and the column width is set to 10, then the visible text would read
"This is text in a ce..."

An ideas, or pre-defind code I can use?

Thanks

Trevor Williams