Formatting a table in Word or Excel

i like this post (click again to cancel)

i dont like this post (click again to cancel)

remove favorite mark from this question (click again to restore mark)

Hi all, When you estimate a model with let say 10 variables and you want to present the result in for example a word-document you can copy and past from the Shazam output. That's the quick and dirty way. How can you make a nice table in Word or excel WITHOUT typing every variable with associated coeff.estimate, and t-value etc. - that's really time-consuming. Any suggestions will be appreciated.

Regards, P.

output

asked Feb 12

Pantera
31 ● 3

1 Answer:

oldest newest most voted

i like this answer (click again to cancel)

i dont like this answer (click again to cancel)

If you are using Formatted Output in the Professional Edition then Word should detect it is already in a table and you may then use the Table Formatting options in MS Word to format it the way you wish.

An alternative method for Plain Output (e.g. with the Standard Edition) is to select the table rows and paste them into MS Excel. From here use the 'Text to Columns' option and select Space as the delimiter and check the 'Treat consecutive delimiters as one' option. Once the data is laid out in separate cells you may then paste it as a table into MS Word and format as above.

link

posted Feb 12