Quotes around fields in CSV
When I save a file in CSV format and reopen it in notepad, it only puts quotes around some fields. How do I get to to save a file with quotes around ALL fields? TIA later! Paul -- SWMagic ------------------------------------------------------------------------ SWMagic's Profile: http://www.excelforum.com/member.php...o&userid=26660 View this thread: http://www.excelforum.com/showthread...hreadid=503065 |
Quotes around fields in CSV
You could write your own macro based on J.E. McGimpsey's code:
http://mcgimpsey.com/excel/textfiles.html SWMagic wrote: When I save a file in CSV format and reopen it in notepad, it only puts quotes around some fields. How do I get to to save a file with quotes around ALL fields? TIA later! Paul -- SWMagic ------------------------------------------------------------------------ SWMagic's Profile: http://www.excelforum.com/member.php...o&userid=26660 View this thread: http://www.excelforum.com/showthread...hreadid=503065 -- Dave Peterson |
All times are GMT +1. The time now is 10:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com