import .CSV file to XP EXcel 2003 worksheet, the seperator is com.

M

ML

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
import file so that it is a actual csv file, no excel cell version 1
How to Write EXCEL files from a FORTRAN Program ? 0
Merging from an Excel file with graphics 1
Excel CSV Files; Creating Of 3
Sumif using partial string 7
Excel VBA macro to auto import new CSV file from fixed directory 1
Import Multiple CSV Files from Same Folder into Open Workbook 5

Top