| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
import .CSV file to XP EXcel 2003 worksheet, the seperator is com.
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do I import data from Microsoft Project 2003 to Excel? | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
| Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
| Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
Hybrid Mode
