Excel VBA- format string length to get a cell height
"lcoreyl " wrote in message
...
Is there a way to trim a text string at "smart" places like a period or
line break?
Use the instr function to find the location of the period and then mid to
trim it
You could write your own function using these to do your smart trim
Keith
|