Isolate a specific value, such as a number value in cells that contain both numbers and letters by using the Excel MID function. Click in the cell where you will display the value you want to isolate.