Excel and CVS
 

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.

Excel and CVS
 

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 DataText to Columns to
parse.


Gord Dibben MS Excel MVP

On Sun, 30 Aug 2009 17:11:01 -0700, summerelli
wrote:

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.

Excel and CVS
 

Thank you.

"Gord Dibben" wrote:

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 DataText to Columns to
parse.


Gord Dibben MS Excel MVP

On Sun, 30 Aug 2009 17:11:01 -0700, summerelli
wrote:

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.