Excel vba - convert string to number

string vba numbers vlookup
user960358 picture user960358 · Sep 30, 2011 · Viewed 151.1k times · Source

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 this in a macro, so I'm not sure about the syntax. Can someone help?

Answer

malificent picture malificent · Sep 30, 2011

use the val() function

Related questions

How Do I Convert an Integer to a String in Excel VBA?

How do I convert the integer value "45" into the string value "45" in Excel VBA?

Read More
Check if a string contains another string

I want to find if a string contains a ","(comma) in it. Do we have any other option other than reading char-by-char?

Read More
How to extract file name from path?

How do I extract the filename myfile.pdf from C:\Documents\myfile.pdf in VBA?

Read More