Re: st: Display special characters in estout

[Dominik Becker <dominik.becker@wiso.uni-koeln.de>]

Dear Miranda, 

this is not really the answer to your question, but have you tried to
open the file with OpenOffice? As far as I know, you can choose the cell
separator before importing a file. You would have to make shure that
"comma" is deselected. Afterwards, you could save it as a conventional
xls-file that would be ready for excel.

Maybe this works.

Best,
Dominik





Am Montag, den 29.03.2010, 14:50 +0100 schrieb Miranda Kim:
> Dear Stata listers,
> I am creating a summary statistics table using estout in Stata 11, and 
> directly exporting this table into excel.
> I am encountering a problem when using the -posthead- option or the 
> -label- option when my string expression contains a comma. This comma is 
>   interpreted as moving to the next cell.
> For example adding the option posthead("Qualification level, percent 
> (no.)") in the esttab call, would put "Qualification level" in the first 
> cell and "percent (no.)" in the next cell, when exporting into excel. 
> Any suggestions would be greatly appreciated.
> Many thanks and best wishes,
> Miranda
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

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