Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Triple Quotes when saving to *.csv | Excel Discussion (Misc queries) | |||
Pivot table # of fields | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) |