Mid and isnumber

[annbc]

Any ideas what is wrong with this formula =1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$10),1)),0),COUNT(1*MID(A1,ROW($1:$10),1)))

This is in column A ~00085965233~

I need to extract only the true number 85965233

 

[annbc]

Thanks for all your help using the function (Mid, right and left) will work.
However my problem is that my string of numbers in column A: will not always be the same at times it could be 12 digits or 8 or 6. I don't want to have to keep changing the formula line by line that is why I need to use "true"

 

[Luck]

=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$10),1)),0),COUNT(1*MID(A1,ROW($1:$10),1)))ctrl,shift,enter