Quote Originally Posted by DRI66
Hello,

This is what you need

VB Code:
  1. Dim MyStr As String
  2. MyStr = Left("Xyzaaa1234567", 6)

Best Regards,
Didier.
The problem with this is that it extracts the first 6 letters. In my program only the last 7 letters are CONSTANT and I need to remove that constant letters.