M
Marc Mercier
I use Excel a lot to extract data from tab delimited files. I used to
export with it, and the "'s Excel inserts around each cell (puts it as first
character and last) which wasn't that much of a problem when the file was
small, but now I have over 600 lines of this. It also inserts a " next to
any other " within that cell. Is there a way to stop Excel from inserting
quotes when exporting as tab delimited?
Example tidbit of file (pipe used to show tab):
ProductPart#|ProductName|"<p><font face=""Arial""><br></font></p><h3
align=""justify"" style=""margin-top: 5; margin-bottom: 5""><font
face=""Arial"" color=""#336699"">
It SHOULD look like:
ProductPart#|ProductName|<p><font face="Arial"><br></font></p><h3
align="justify" style="margin-top: 5; margin-bottom: 5"><font face="Arial"
color="#336699">
export with it, and the "'s Excel inserts around each cell (puts it as first
character and last) which wasn't that much of a problem when the file was
small, but now I have over 600 lines of this. It also inserts a " next to
any other " within that cell. Is there a way to stop Excel from inserting
quotes when exporting as tab delimited?
Example tidbit of file (pipe used to show tab):
ProductPart#|ProductName|"<p><font face=""Arial""><br></font></p><h3
align=""justify"" style=""margin-top: 5; margin-bottom: 5""><font
face=""Arial"" color=""#336699"">
It SHOULD look like:
ProductPart#|ProductName|<p><font face="Arial"><br></font></p><h3
align="justify" style="margin-top: 5; margin-bottom: 5"><font face="Arial"
color="#336699">