text: The text string that you want to convert into a number. In our dataset, we use the VALUE function to convert the numeric text extracted with the LEFT function into a number that Excel can ...