Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps