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 |
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 |
All times are GMT +1. The time now is 11:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com