Tables to Excel- rows and columns does not stay in place!

[Anna Stubbendorff]

Hi all!

I have created a table in Stata. When copying it as table and paste it into Excel the values does to paste in columns. When using "text to columns" in Excel the rows move around, and some nubers are split into two. There must be a better way. How do I solve this?

After pasting my table in Excel.

After applying "text to columns" in Excel.

[George Ford]

probably need to get rid of the % info and compute in excel. copy/paste table doesn't do well with more info in a cell than one thing. or else just clean it up manually.

or you could get counts and percentages in separate tables, and then concatenate in excel.

or, eliminate any spaces in the data in excel, do text to columns, and then add spaces back in.

[Clyde Schechter]

If you are running version 17 or 18 and you created the original Stata table using -dtable- or -table-, instead of copy/pasting the table, use -collect export- to the Excel file.