Yahoo (Download To Spreadsheet ) data

[cecja]

Hi,

I will be great if someone can help me to figure out <why when i Download DATA To Spreadsheet > from yahoos site it comes all mess.


Thank you so much.

 

[Racer]

What do you find wrong with it?

 

[salicsale]

I do it on next way
1) Copy that data to the note pad
2) Delete data that I don’t need (company full name etc.)
3) Copy that data
4) In excel select A1 and past data
5) Then select A column and go in “Data”/Text to Columns/check the coma delimiter and finish.
You should get spreadsheet with separated data in each column and row.