How do I make it so the cel does not display all the info?

[proof]

http://img172.imageshack.us/img172/3105/excelso1.gif

If you look at the picture I a have provided above, although all the cells in column H contain the same information, the first three cells have the information truncated, while the others are displaying the entire info. I would like all the info to be truncated like the first 3 cells, and only entirely visible when clicking on the individual cell.

Can anyone help me with this?

Thanks!

 

[Andrew Poulsom]

To do that you will need to enter something in column I, like a space character or ="".

 

[Oaktree]

Try putting a single quote (used as a text qualifier) in each blank cell in column I where you'd like column H to truncate.

 

[proof]

Thanks, I don't know why that didn't occur to me.