ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   when excel save as csv,double quotes in an cell issue (https://www.excelbanter.com/excel-discussion-misc-queries/163593-when-excel-save-csv-double-quotes-cell-issue.html)

Frank

when excel save as csv,double quotes in an cell issue
 
Hi,
When i want to save excel book as csv file , when the cell content has
doulble quotes. this double quotes will be occer twice in csv file.
For instance,
the cell content is hh"rr"ee in excel , this content in csv will be
"hh""rr""ee".
Could someone tell me why? i just know "If a cell contains a comma, the cell
contents are enclosed in double quotation marks."

thanks


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com