In this post we will see how to delete numeric values from a numeric column, in other words we will remove extract all numeric values from alphanumeric value.
It involves scanning the data in the field and removing non numeric values from them if they do not match [0-9].
Below is the combination of numeric and non numeric values in column A from which we will get numeric values in a column B.
Enter the formula =NPV(-0.9,,IFERROR(MID(A1,1+LEN(A1)-ROW(OFFSET(A$1,,,LEN(A1))),1)%,””)) in cell B1 and press Ctrl+Shift+Enter as this is an array formula.
Now copy the formula to the entire range till where you have the data in column A.
Hope this helped.
