SHAZAM Community
Ask Your Question
0

Formatting a table in Word or Excel

asked 2012-02-12 11:32:46 +0000

Pantera gravatar image

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.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
1

answered 2012-02-12 11:58:52 +0000

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.

edit flag offensive delete link more

Comments

Thanks a lot for your answer.

Pantera gravatar imagePantera ( 2012-02-12 12:40:24 +0000 )edit
Login/Signup to Answer

Question Tools

Stats

Asked: 2012-02-12 11:32:46 +0000

Seen: 493 times

Last updated: Feb 12 '12