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

If for example x 5 and is stored as string you can also just x x 0 and the new x would be stored as a numeric value

[string] Excel vba - convert string to number

use the val() function

• How to split a string in two and store it in a field • String method cannot be found in a main class method • Kotlin - How to correctly concatenate a String • Replacing a character from a certain index • Remove quotes from String in Python • Detect whether a Python string is a number or a letter • How does String substring work in Swift • How does String.Index work in Swift • swift 3.0 Data to String? • How to parse JSON string in Typescript

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

• how to display a javascript var in html body • How to label scatterplot points by name? • Allow 2 decimal places in <input type="number"> • Why does the html input with type "number" allow the letter 'e' to be entered in the field? • Explanation on Integer.MAX_VALUE and Integer.MIN_VALUE to find min and max value in an array • Input type "number" won't resize • C++ - how to find the length of an integer • How to Generate a random number of fixed length using JavaScript? • How do you check in python whether a string contains only numbers? • Turn a single number into single digits Python

• Check if an excel cell exists on another worksheet in a column - and return the contents of a different column • "Unable to get the VLookup property of the WorksheetFunction Class" error • Comparing two columns, and returning a specific adjacent cell in Excel • VLook-Up Match first 3 characters of one column with another column • Combining COUNT IF AND VLOOK UP EXCEL • Excel- compare two cell from different sheet, if true copy value from other cell • Vlookup referring to table data in a different sheet • Excel - find cell with same value in another worksheet and enter the value to the left of it • Remove #N/A in vlookup result • Excel vba - convert string to number