ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   [Excel 2000] Saving to .csv (https://www.excelbanter.com/excel-worksheet-functions/174707-%5Bexcel-2000%5D-saving-csv.html)

Floor

[Excel 2000] Saving to .csv
 
If I save an Excel document as .csv (either MS-DOS format or just csv
format), the output is between quotes.
Example "my_name;myadress;myplace" Can you pls tell me how to get rid of
these quotes?

--
Floor



David Biddulph[_2_]

[Excel 2000] Saving to .csv
 
Set your list separator in Windows/ Regional Settings to comma rather than
semi-colon, then it won't need to put quotes round the string which includes
semi-colons.
--
David Biddulph

"Floor" wrote in message
...
If I save an Excel document as .csv (either MS-DOS format or just csv
format), the output is between quotes.
Example "my_name;myadress;myplace" Can you pls tell me how to get rid of
these quotes?

--
Floor




Floor

[Excel 2000] Saving to .csv
 
David:

Set your list separator in Windows/ Regional Settings to comma rather than
semi-colon, then it won't need to put quotes round the string which
includes semi-colons.


Will do, thanks!

--
Floor




All times are GMT +1. The time now is 12:50 PM.

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