Download a .CSV file from internet to Windows XP Excel 2003 (SP1). The text
delimitor is comma. How do I change the worksheet to have the text delimited
by column? that means each text filed is imported into each column.
Thank you
Download a .CSV file from internet to Windows XP Excel 2003 (SP1). The text
delimitor is comma. How do I change the worksheet to have the text delimited
by column? that means each text filed is imported into each column.
Thank you
ML
Change the .csv extension to .txt then open that *.txt file.
The Text Import Wizard will appear and you can parse your data with "delimited
by" comma.
Gord Dibben Excel MVP
On Sat, 22 Jan 2005 08:19:02 -0800, "ML" <[email protected]> wrote:
>Download a .CSV file from internet to Windows XP Excel 2003 (SP1). The text
>delimitor is comma. How do I change the worksheet to have the text delimited
>by column? that means each text filed is imported into each column.
>Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks