Excel trick: pasting an entire column

Question

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.

note that you can use the `Data>Convert` functions of Excel to split your postal codes and then transpose them (`Copy>Pase Special>Check Transpose`to change from horizontal to vertical) — JMax, Jul 20 '12 at 08:22

score 0 · Answer 1 · answered Jul 20 '12 at 08:19

0

Yes you can do so surely..just format them like this in notepad..

and paste at the desired location in excel..

answered Jul 20 '12 at 08:19

000

3,976
4
25
39

score 0 · Answer 2 · 2012-07-20T08:27:38.953

0

Just format your postal codes like that:

then select everything and paste it into the first cell in excel.

Do you need help formatting the postal codes? You can use regular expressions or search & replace in notepad++ to achieve the needed format.

I have not tested it, but it should work in OpenOffice Calc as well!

edited Jul 20 '12 at 08:27

answered Jul 20 '12 at 08:22

Excel trick: pasting an entire column

2 Answers2