Excel vba - convert string to number - Stack Overflow

So, I used the left function to take the first 4 characters of a string and I need to run a vlookup with it, but it won't find the match because it's looking through numbers. I want to do ...

stackoverflow.com