hunsnowboard
07-08-2010, 12:54 PM
Hi Everyone!
Just wondering if this can be done?
I have a column in my excel file where there is text in each record. The text in most of the records overlaps the width of the cell. I was just wondering if it is possible to write a macro which auto ellipses the overlapping texts in the relevant cells.
I mean something like this:
John Doe Limited Company <- full text in the cell
l John Doe Limitl <- the text with the width of the cell without auto ellipse
l John Doe Li...l <- the text with the width of the cell with auto ellipse
Of course I wouldn't like text to be deleted, just to show ellipse when close to the border of the cell.
Is it possible to have such a macro?
Thank you in advance!
Just wondering if this can be done?
I have a column in my excel file where there is text in each record. The text in most of the records overlaps the width of the cell. I was just wondering if it is possible to write a macro which auto ellipses the overlapping texts in the relevant cells.
I mean something like this:
John Doe Limited Company <- full text in the cell
l John Doe Limitl <- the text with the width of the cell without auto ellipse
l John Doe Li...l <- the text with the width of the cell with auto ellipse
Of course I wouldn't like text to be deleted, just to show ellipse when close to the border of the cell.
Is it possible to have such a macro?
Thank you in advance!