I am trying to get a cell to look at another cell and if the cell contains a number return that value in the cell i am in so for example if cell "F1" contains "7B1" return 7 in Cell A1.
My list in column "F" will vary numerically from 7 to 10 and the text will vary also