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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I change *.CSV excel file to column seperated file? (https://www.excelbanter.com/excel-discussion-misc-queries/33798-how-do-i-change-%2A-csv-excel-file-column-seperated-file.html)

Pankaj

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?

Barb R.

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?

Gord Dibben

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?

All times are GMT +1. The time now is 08:22 PM.