http://support.microsoft.com/default...b;en-us;291296
Procedure to export a text file with both comma and quote delimiters in
Excel

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
Thanks for your reply.

I can finish the steps to create a txt file with quotes around each
fields. But eventually user needs each file with the extension .csv. So
I tried to open .txt from Excel then save it to .csv, however, if user
view the .csv file with notepad, all quotes are gone. But if i open the
.txt file from notepad, then do a saveas to a .csv format, then review
the new .csv file from notepad, i got the result user wants to see -
quotes with each filed. for example,

"Name", "Street", "City", "State",

But how can i make this a macro step for user?

Please help.

Thanks.