Thread: editing strings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
  
Posts: 983
Default editing strings
strMyString = left(trim(strOldstring)), len(trim(strOldstring))-3)

HTH

"Himszy" wrote:

How do I remove the last three letters of a string?



Reply With QuoteReply With Quote