Excel trick: pasting an entire column
===

I have a list of postal codes. I want to paste them into Excel in such
a way that they appear all in one column (which is not the first column).
Can this be done? If so than in what format should the postal codes be so
that they are pasted vertically, one cell at a time, rather than horizontally.

Furthermore, I would also like to know whether the same trick is possible in
OpenOffice Calc as well.

Thanks,

John Goche