View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Change the .CSV extension to .TXT and open as a text file.

The text import wizard will pop up to help separate the data to columns.


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 06:58:03 -0700, Pankaj
wrote:

The useful data inported from remote is in excel *.csv format and to check it
I need to convert it so that it can be seperated by columns. Is there any way
to do this?