View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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