Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Double-clicking .xls file opens Excel but doesn't open the file DG Excel Discussion (Misc queries) 4 January 6th 06 02:20 AM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Getting data from another excel file Union70 Excel Discussion (Misc queries) 0 May 2nd 05 02:17 PM
Changing the format of an Excel output file made by Microsoft Access Amir Excel Discussion (Misc queries) 2 May 1st 05 12:57 AM
double click a xls file and start Excel but without the file Danyi, Attila Excel Discussion (Misc queries) 2 December 22nd 04 02:19 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"