saving text with quote and comma delimiters

[Joe]

Excel nicely imports text files with comma and quote
delimiters, but I can't figure out how to use Save as to
export a worksheet into the same format.

For example, I can import this line:

1,2,3,4,"test1","test2"

and I get 6 columns. However, I would then like to
manipulate the data within Excel and then output the data
with commas and quotes so that the saved file has the
original format.

If you know how to do this, please send me the solution.

Joe
(e-mail address removed)

 

[Ian Paterson]

Save As ... .csv file?

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;213448&Product=xlw
XL2000: Procedure to Export a Text File with Both Comma and Quote Delimiters

http://support.microsoft.com/default.aspx?scid=kb;en-us;291296&Product=xlw
XL2002: Procedure to Export a Text File with Both Comma and Quote Delimiters

http://support.microsoft.com/default.aspx?scid=kb;EN-US;123183
Procedure to Export Text File with Comma AND Quote Delimiter

 

[Joe]

Thanks. These macros don't do exactly what I want as
they change every column into the ," ", format. However,
having looked at the VBA code, I think I can make it work
by adjusting it to only do the columns that I want. This
is going to be great for the project I'm starting. Thanks
lots!
Joe