2
$\begingroup$

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?

$\endgroup$
1
  • 1
    $\begingroup$ 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 $\endgroup$
    – user1066
    Jul 30 '18 at 18:57
3
$\begingroup$

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.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.