Hopefully a very simple question requiring a very simple answer.
I have the part number stored as a string
FileName = "123456-01"
How do I extract the first 4 characters from this variable and place them in another variable.
I tried using InStr but I could not figure out how to get it to work.
Can anyone help me?