View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michele[_2_] Michele[_2_] is offline
external usenet poster
 
Posts: 4
Default Spreadsheet to .txt.

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