Try this in B2:

=SUBSTITUTE(LEFT(RIGHT(A2,10),8),"_","")+0