Excel: How do I parse the last 4 numbers in a 6 digit number into a new cell?

Question

I have 400 6 digit numbers, and I need the last 4 numbers put into a new cell

Answer 1

Assume the 6 digit number is in cell A1 then put this formula in B1:

=MID(A1,3,4)