View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default 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