saving text with quote and comma delimiters

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)
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top