How do I change *.CSV excel file to column seperated file?

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?

Open the CSV file and SAVE AS the filetime you need.

"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?

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 <[email protected]>
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?