Saving As .CSV

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

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

Grant wrote:
>
> 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

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

Grant wrote:

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

"Bob I" <birelan@yahoo.com> wrote in message
news:u9kYbHKcHHA.4460@TK2MSFTNGP04.phx.gbl...
> Which "Save As" CSV version did you pick from the drop down box?
>
> Grant wrote:
>
>> 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
>

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" <petersod@verizonXSPAM.net> wrote in message
news:46096868.90F04681@verizonXSPAM.net...
> 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
>
> Grant wrote:
>>
>> 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

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 wrote:
>
> 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" <petersod@verizonXSPAM.net> wrote in message
> news:46096868.90F04681@verizonXSPAM.net...
> > 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
> >
> > Grant wrote:
> >>
> >> 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

--

Dave Peterson

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" <petersod@verizonXSPAM.net> wrote in message
news:46099CA5.6445AD9F@verizonXSPAM.net...
> 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 wrote:
>>
>> 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" <petersod@verizonXSPAM.net> wrote in message
>> news:46096868.90F04681@verizonXSPAM.net...
>> > 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
>> >
>> > Grant wrote:
>> >>
>> >> 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
>
> --
>
> Dave Peterson

It's the one that looks like:

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



Grant wrote:
>
> 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" <petersod@verizonXSPAM.net> wrote in message
> news:46099CA5.6445AD9F@verizonXSPAM.net...
> > 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 wrote:
> >>
> >> 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" <petersod@verizonXSPAM.net> wrote in message
> >> news:46096868.90F04681@verizonXSPAM.net...
> >> > 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
> >> >
> >> > Grant wrote:
> >> >>
> >> >> 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
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

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.

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4609F24A.E32E1355@verizonXSPAM.net...
> It's the one that looks like:
>
> "CSV (Comma delimited)(*.csv)"
>
>
>
> Grant wrote:
>>
>> 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" <petersod@verizonXSPAM.net> wrote in message
>> news:46099CA5.6445AD9F@verizonXSPAM.net...
>> > 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 wrote:
>> >>
>> >> 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" <petersod@verizonXSPAM.net> wrote in message
>> >> news:46096868.90F04681@verizonXSPAM.net...
>> >> > 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
>> >> >
>> >> > Grant wrote:
>> >> >>
>> >> >> 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
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson

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

Grant wrote:

> 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.
>
> "Bob I" <birelan@yahoo.com> wrote in message
> news:u9kYbHKcHHA.4460@TK2MSFTNGP04.phx.gbl...
>
>>Which "Save As" CSV version did you pick from the drop down box?
>>
>>Grant wrote:
>>
>>
>>>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
>>
>
>