How do I copy a mathematica column to paste in excel?

Question

I have a list of elements that I transform into a column:

a = {1, 2, 3, 4, 5}

Column[a]  

1
2
3
4
5

How do I print this column so it can be copy-pasted in Excel? Any alternative way to accomplish this?

An alternative to cut-and-paste it to export as an xls file. Export["a.xls", a]. All explained in How to Export a Spreadsheet — user1066, Jul 30 '18 at 18:57

Chris Degnen · Accepted Answer · 2018-07-30T18:53:33.663

3

Select the column, Copy As -> Plain Text. Paste into Excel.

You can also use TableForm[a] as well as Column[a].

For copy & paste from Excel to Mathematica see this answer.

edited Jul 30 '18 at 18:53

answered Jul 30 '18 at 18:46

Chris Degnen

1 Answers1