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" 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