Spreadsheet to .txt.

[Michele]

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

 

[Myrna Larson]

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.