Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double-clicking .xls file opens Excel but doesn't open the file | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Getting data from another excel file | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
double click a xls file and start Excel but without the file | Excel Discussion (Misc queries) |