st: RE: Transferring tables into excel when "Copy Table" option only half works

["Radwin, David" <dradwin@rti.org>]

I agree with the others that a command to output your results directly to an Excel-friendly format (including tab-separated or comma-separated values) is generally the best solution. 

However, if you need to copy tables anyway, you may be able to fix your problem by selecting the table in exactly the right spot in the results window. I don't know if I can describe a generic solution that applies to all types of tables. Start by positioning the cursor immediately to the left of the first character of the first column header, and experiment to see what works.

For an explanation, see:

http://www.stata.com/statalist/archive/2007-07/msg00238.html

David
--
David Radwin, Senior Research Associate
Education and Workforce Development
RTI International
2150 Shattuck Ave. Suite 800, Berkeley, CA 94704
Phone: 510-665-8274

www.rti.org/education


> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of Elizabeth Loughnan
> Sent: Friday, November 08, 2013 10:52 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Transferring tables into excel when "Copy Table" option only
> half works
> 
> Dear Stata users,
> 
> I am trying to export a Stata results table into excel, using the Copy
> Table option. It is correctly copying some columns, but a few are folded
> into others - e.g. so my table has 3 columns instead of 5. The missing 2
> are doubled up in the 3 successfully transferred columns, with a few
> spaces between what should be in one column and what should be in another.
> 
> I am using STATA 10.
> 
> I have checked searching on the Stata website, and UNC. UNC suggests
> copying the top and base of table separately. This helps but I still get
> some instances of 2 columns folding into 1.
> 
> Thanks in advance for tips.
> 
> Best,
> 
> Elizabeth


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/