Excel and CVS

  • Thread starter Thread starter summerelli
  • Start date Start date
S

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.
 
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
 
Thank you.

Gord Dibben said:
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
Click to expand...
 
Back
Top