Spreadsheet to .txt.
You can import the existing file into Excel. In the Text File Wizard, specify
that the data is delimited, and the delimiter is a space.
Once you've done that, then just do a File/Save As, and select CSV from the
"Save As Type" box.
On Sun, 10 Oct 2004 21:35:37 -0700, "Michele"
wrote:
Not sure if I am in the right place here.
Trying to manipulate Yahoo historical stock price data
which downloads in spreadsheet format and looks like this:
(imagine columns)
^DJI 02/10/95 4890.0 4896.2 4889.2 4895.6
I need the data in .txt format and to look like this:
^DJI,19951002,4890.0,4896.2,4889.2,4895.6
I am not hopeful on this one but some of you smart guys
may have an idea.
Thanks in advance.
Michele
|