PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?UGFua2Fq?=
Guest
Posts: n/a
 
      5th Jul 2005
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?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QmFyYiBSLg==?=
Guest
Posts: n/a
 
      5th Jul 2005
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?

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      5th Jul 2005
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 <(E-Mail Removed)>
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?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 & xml-file: change referring path of input file? Jannick Asmus Microsoft Excel Discussion 0 20th Jan 2008 11:29 PM
Comma Seperated File =?Utf-8?B?UmljYXJkbzAzMDM=?= Microsoft Excel Worksheet Functions 2 10th Apr 2007 04:45 PM
comma seperated file import =?Utf-8?B?VGhlIHN1bg==?= Microsoft Excel Misc 0 10th Jan 2007 06:37 AM
saveas (;) seperated csv file [Problem] Murat Demir Hekimošlu Microsoft Excel Discussion 3 20th Jul 2005 12:12 PM
VBA Macro to copy an column from one Excel file into another file =?Utf-8?B?U2Ft?= Microsoft Excel Programming 4 3rd Jul 2005 03:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:25 AM.