I have a series of codes, such as A-0A-01-123456v01. I need to get rid of everything from the v on. It's always
going to be 3 characters, but the start can be 11-15 (like AAA-02-123456v02).
I can use mid or left, but they assume consistency of character numbers.
I can use right to isolate the v01 part, but that just gives me the part I want to be rid of.
Any ideas? There has to be something simple I'm missing.

Thanks in advance!