ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Save As CSV (https://www.excelbanter.com/excel-discussion-misc-queries/191371-save-csv.html)

rodchar

Save As CSV
 
hey all,
Is there a way to suppress the Text Qualifiers when I save my file as a CSV
file?

thanks,
rodchar

Dave Peterson

Save As CSV
 
If you just let excel do the work, then I don't think so.

But you could do the work yourself.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(or maybe you could build your own formula and copy|paste into Notepad.)

Check out Earl's Text Write program first. It may do exactly what you want
right out of the box.

rodchar wrote:

hey all,
Is there a way to suppress the Text Qualifiers when I save my file as a CSV
file?

thanks,
rodchar


--

Dave Peterson


All times are GMT +1. The time now is 10:29 AM.

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