View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Fast way to truncate string

"GS" wrote:

I went with Mid$() so you could start anywhere. Just bear in mind the
start position MUST be before the end position!


Yup, that makes sense. Setting "lStart" equal to 1 by default seems
to be the best way. 8)