how to export a text file with text qualifier

[Flicker]

I did a search but it seems I can't get the answer I want to save an excel file as a text file but I want all text should have text qualifier (double quote " ") for each text in each cell. I try many format but it seems that the text file does not have text qualifier. I did not know what I did wrong. Maybe Excel cannot export as a text file with double quote. Example data in Excel aaa bbb1 cc c Example data in text file that I expect "aaa" , "bbb1" , "cc c" or "aaa" "bbb1" "cc c"

 

[xenou]

Excel csv does not include those double quotes around all fields - only numbers or text with commas in them, I think. Here are some solutions. I'm sure I've seen a few here at MrExcel too but I haven't saved the links (I'm sure BrianB has a thread on this somewhere, for instance).

I've not tried the utility from calagday but it may be worth a shot - I'm not familiar with the site/blogger though. vbaexpress and mcgimpsey have published lots of good code and are trustworthy (if you can implement their vba solutions). ****'s clicks is also good (offhand, I'm not sure the code there allows for text qualifiers with double quotes though - but it could probably be modified for that).

http://www.calagday.com/?p=50
http://vbaexpress.com/kb/getarticle.php?kb_id=805
http://www.dicks-blog.com/archives/...http://www.mcgimpsey.com/excel/textfiles.html

Edit:
Some reading on csv in general here:
http://www.csvreader.com/csv_format.php