Cutoff text in Excel Cell and show ellipsis

I have an Excel 2007 spreadsheet with one text based column containing some large text data. I want to be able to have the text in this cell reduced to show certain fixed number of lines(maybe 2) and where the text cuts off, display an ellipsis which indicates that there is more text. The user should be able to see the full text when that particular cell is double clicked.

This will allow my rows to be of uniform size still allowing the user to look at the full text when double clicked and an ellipsis as an indication to the user that there is more text than what is displayed.

Hi,

I am not sure on how to add a indication mark like ellipsis in the cell.

But how about conditional formatting based on the cell character count. The attached spread sheet, highlights the cell if the range E:E contains more than 40 characters.

If the user double clicks it will show the full text.

Will something like this works?

This works for me.