saving text with quote and comma delimiters

  • Thread starter Thread starter Joe
  • Start date Start date
J

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)
 
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
 
Back
Top