Quote:
Originally Posted by Ferra
2007
|
Hmmm I don't think you can do it without creating more rows/cols. I suspect you could probably rig up an IF statement based on the total characters and if it exceeds X characters then only show X characters and then hide the original input col but if you expand that collum it won't show any more of the word than the if statement requested and all and all would be way more trouble then it's worth and I can't figure out the formula to do it.
Or you could put a small collum beside the one with the text in it and have it use an =IF(LEN(A1)>8, "…") this would return an ... in the adjacent cell. A1 being what ever the origional cell address is and 8 or what ever being the total number of characters typically visible in the cell, adjust as you like.