Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|