Another

=MID(A2,7,6)*1

The *1 converts the result into numeric so it can be omitted if you don't need that.
The 6 can be any number >= the number of characters needed. So you can use, say, 50 if you have varying lengths of strings.