I have a CSV file that I want to import to excel, edit, and save back as CSV.
The problem that I encounter is with Text Import Wizard: I open a new Excel file, then Data > From Text, and in The text Import Wizard I pick delimited>comma>Finish. This shows the data in easy-to-read columns. I make the needed changes, then I want to export as CSV, but if I go through File > Save As > CSV, it's no longer in the original format, it does not have commas/quotation marks because the Import Wizard removed them.
Is it possible to go in reverse with the import wizard and add back the commas? How can one import CSV, make changes, and export to CSV keeping the formatting exactly as it was?
I am using Excel 2007, Windows 7 PC.
Thanks for your help.
Text Qualifier
to{none}
or whatever it is using (perhaps single quotes?)