I have used the Excel functions LEFT, MID ... You must put curly brackets around the entire set of delimiters, separate each delimiter with a comma, and put quotes around each delimiter in the set. In ...
Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.