ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   convert spreadsheet to csv with double quotes (https://www.excelbanter.com/excel-discussion-misc-queries/29020-convert-spreadsheet-csv-double-quotes.html)

Bren Lane

convert spreadsheet to csv with double quotes
 
I need to be able to save a spreadsheet as a csv file, using comma delimited
but also having double quotes around each field. I'm running Excel 2000, on
Windows XP sp2. Any help would be appreciated.


JE McGimpsey

Take a look he

http://www.mcgimpsey.com/excel/textf...#csvwithquotes



In article ,
Bren Lane <Bren wrote:

I need to be able to save a spreadsheet as a csv file, using comma delimited
but also having double quotes around each field. I'm running Excel 2000, on
Windows XP sp2. Any help would be appreciated.


Earl Kiosterud

Bren,

Try the Text Write Program at www.smokeylake.com/excel. It's ready to go.
There's an option for quote marks around all fields in the Setup sheet.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Bren Lane" <Bren wrote in message
...
I need to be able to save a spreadsheet as a csv file, using comma
delimited
but also having double quotes around each field. I'm running Excel 2000,
on
Windows XP sp2. Any help would be appreciated.




Gde Agung

convert spreadsheet to csv with double quotes
 
Convert the excel into Access and then from Access save it as CSV. Access
adds double quote on the text output format

"Bren Lane" wrote:

I need to be able to save a spreadsheet as a csv file, using comma delimited
but also having double quotes around each field. I'm running Excel 2000, on
Windows XP sp2. Any help would be appreciated.



All times are GMT +1. The time now is 02:13 PM.

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