Copy & paste PART of cell to new sheet

I have I spreadsheet that has one column which looks like this:

A320
B487
C583
C394
D692

I need to copy and past just the numerical portion of those cells (the entire column into sheet 2 of that workbook). It should be super simple (ALL of these are only four characters so it doesn't even get messy there) but I am having some difficulties - any help?

I am trying to do this so that I can print them as labels in word. Is that going to involve mail merging? or is there an easier way to do this?

Thanks for any help you can offer!