Saving As .CSV

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

Hello, here's the situation: I downloaded an .xls file from my broker and
opened it in Excel. The original file was delimited by commas and I had to
choose comma delimited in order for Excel to display it in columns/rows
correctly. I made some changes to the file, then saved it with a new name.
The problem is, I can find no way to save it as a comma delimited file
again. Saving it as a Workbook places quotes around the commas and creates
spacing between text (when I view it in Wordpad), and saving it as a Text
File (Tab delimited) does just that--makes it TAB delimited, not comma
delimited. I just need my file to be a comma delimited text file again,
like it was originally. Any ideas?

Thanks in advance,

Grant
 
It doesn't give me the option to save as CSV. The only "save as" options
are: Excel Workbook, XML Spreadsheet, Single File Webpage, Web Page,
Template, and Text (Tab Delimited). As I said, I tried Workbook and Text.
 
Thanks Dave, that first one did the trick. What I don't understand is why
there simply isn't an option to save as Text-Comma Delimited rather than
Text-Tab Delimited. Anyhoo, I got what I need. Thanks again.

Grant
 
Actually, there is a "CSV (Comma delimited)(*.csv)" option.

It just doesn't use the same rules as what you want.

(Or your rules don't use the same rules as what MS wants...)
 
Would you care to share exactly WHICH option allows me to save it to .csv?
Because, as I told Bob, when I "Save As," I see no comma delimited option,
only Text (Tab Delimited) and some others. Thanks.
 
It's the one that looks like:

"CSV (Comma delimited)(*.csv)"


Would you care to share exactly WHICH option allows me to save it to .csv?
Because, as I told Bob, when I "Save As," I see no comma delimited option,
only Text (Tab Delimited) and some others. Thanks.
Click to expand...
 
I'm such an idiot. I didn't scroll down through the menu. I thought the
five options I mentioned were all there were. Arrgh. Thanks for the help,
anyway.
 
I see in your other post, you "discovered" the rest of your "CSV"
options. You ought to be good to go!
 
Back
Top