Forum Discussion
Text field may contain a 5 digit code, and if so need to extract it to its own column
So my title data sometimes contains a code that tells me important information about the item, my ultimate goal is to use this code with a vlookup function to autofill other fields. My problem is tha...
Hello Modnar1
If they data are in the same format (the numbers you need to extract) is 5 digits and always at the beginning of the text, then you would use this formula
=LEFT(A1,5) --> this way the result will be 13112 as a text
=NUMBERVALUE(LEFT(A1,5)) --> the result will be converted into numbers,