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

G

Guest

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

import file so that it is a actual csv file, no excel cell version 1
Converting a CSV file to an Excel file 3
converting text to columns 1
Import Problem 2
*.csv format change if .xlt save as .csv in Excel 2007 1
Excel 2007/Vista: Missing file name on import external data connection 1
Need to change text to csv 3
Run-time error ‘13’ mismatch type 1

Top