Quote:
Originally Posted by TheNewGirl
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.
|
so can I do that in office 2010? (I was thinking about upgrading anyway)
I actually have no problem writing the forumla like what you describle...only problem with manual formula is that... everytime I change the font/size, column width, i will have to re-write the formula again.. (plus the formula will be based on word counts, but not every word/numbers/space take up the same width)