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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Save Excel file with certain columns with fixed width 3
excel to csv 1
Make first imported CSV row into column names ? 3
ONE xls column to file? 2
Import Problem 2
Access Importing csv daily files into access 2007 1

Back
Top