I'm sorry...
I would put the formula =RIGHT(A2,4) in cell B2, then copy it down.

to copy down:
If you move your mouse over the bottom right corner of the cell that you want to copy, you can then click and drag down to cell B2205, and the cells will automatically reference the appropriate row in column A.