topic Re: Export to excel: remove apostroph in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154445#M12076 <HTML><HEAD></HEAD><BODY><P>Thank you. That answers my first question.</P><P></P><P>If it were possible, I'd export my SAS table directly into that other application. However, that application only welcomes excel-files.</P><P></P><P>And the main problem remains: I'm not able to remove the leading single quotes. (Or more accurate: if I remove it, Excel automatically puts it back.)</P></BODY></HTML> Mon, 03 Nov 2014 14:39:06 GMT ThomasD 2014-11-03T14:39:06Z Export to excel: remove apostroph https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154443#M12074 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I prepare tables in SAS EG 4.3 to later export them to SAS. All variables are character fields.</P><P>After exporting, every cell in the excel-file automatically gets preceded by an apostrophe ( ' ). </P><P></P><P>I strongly suspect this to be problematic when importing that excel-file into another application.</P><P></P><P>I am not able to change this. Things I tried to undo this:</P><UL><LI>copying the data into another excel</LI><LI>lift all kinds of file and cell securities</LI><LI>...</LI></UL><P></P><P>Can someone explain</P><UL><LI>why the apostrophe is there ? To mark a text/character field ? </LI><LI>how to remove the apostrophes in every cell ?</LI></UL><P></P><P>Thank you.</P><P></P><P>Thomas</P></BODY></HTML> Mon, 03 Nov 2014 14:15:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154443#M12074 ThomasD 2014-11-03T14:15:46Z Re: Export to excel: remove apostroph https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154444#M12075 <HTML><HEAD></HEAD><BODY><P>The leading apostrophe or single quote is used to signify character fields. Welcome to the wonderful world of Excel, and The Folly That Is Thinking That Excel Is Any Good For Business Intelligence.</P><P>If you remove the leading single quote, fields with numeric values will be treated as numbers in Excel (leading 0s removed etc).</P></BODY></HTML> Mon, 03 Nov 2014 14:32:10 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154444#M12075 Kurt_Bremser 2014-11-03T14:32:10Z Re: Export to excel: remove apostroph https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154445#M12076 <HTML><HEAD></HEAD><BODY><P>Thank you. That answers my first question.</P><P></P><P>If it were possible, I'd export my SAS table directly into that other application. However, that application only welcomes excel-files.</P><P></P><P>And the main problem remains: I'm not able to remove the leading single quotes. (Or more accurate: if I remove it, Excel automatically puts it back.)</P></BODY></HTML> Mon, 03 Nov 2014 14:39:06 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154445#M12076 ThomasD 2014-11-03T14:39:06Z Re: Export to excel: remove apostroph https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154446#M12077 <HTML><HEAD></HEAD><BODY><P><EM>However, that application only welcomes excel-files.</EM></P><P><EM><BR /></EM></P><P>Does that mean only .xls and .xlsx, or anything that is also accepted by excel, like .xml or .csv?<EM><BR /></EM></P></BODY></HTML> Mon, 03 Nov 2014 14:43:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154446#M12077 Kurt_Bremser 2014-11-03T14:43:21Z Re: Export to excel: remove apostroph https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154447#M12078 <HTML><HEAD></HEAD><BODY><P>I can't offer a perfect fix, but you might either use the trim-function in excel (depends on your data), or export as csv and open with excel or use proc export, or in excel: "data" &gt; "text to columns" &gt; text qualifier = none.</P></BODY></HTML> Mon, 03 Nov 2014 15:41:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-to-excel-remove-apostroph/m-p/154447#M12078 user24feb 2014-11-03T15:41:12Z