Saving As .CSV

[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

 

[Dave Peterson]

You could use a macro and write code and have complete control over what you
write.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

 

[Bob I]

Which "Save As" CSV version did you pick from the drop down box?

 

[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.

 

[Grant]

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

 

[Dave Peterson]

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...)

 

[Grant]

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.

 

[Dave Peterson]

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.

 

[Grant]

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.

 

[Bob I]

I see in your other post, you "discovered" the rest of your "CSV"
options. You ought to be good to go!