Excel and CVS

[summerelli]

Im exporting cvs files from yahoo store into Excel. The data imports into
one column (A). How do I import it so that there are several colums so I can
delete the data I don't need? Thank you in advance.

 

[Gord Dibben]

If possible change the *.csv file to *.txt

Open that and the Text Wizard will pop up allowing you to parse the data.

Or bring in the *.csv data into one column then use Data>Text to Columns to
parse.


Gord Dibben MS Excel MVP

 

[summerelli]

Thank you.

If possible change the *.csv file to *.txt

Open that and the Text Wizard will pop up allowing you to parse the data.

Or bring in the *.csv data into one column then use Data>Text to Columns to
parse.


Gord Dibben MS Excel MVP