| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving XLS file as CSV
I have an xls file with worksheet made up of 3 columns of data. I save
it in Excel 2003 as csv file. When I open the csv file, the columns are lumped into one column. When I do the same thing in Excel 2000, 3 column appear and this is the desired result. How do I make 3 columns appear in excel 2003? Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving XLS file as CSV
"I save it in Excel 2003 as csv file" << Why do this? Save as an xls
file - Problem solved. "Roman" wrote in message oups.com: I have an xls file with worksheet made up of 3 columns of data. I save it in Excel 2003 as csv file. When I open the csv file, the columns are lumped into one column. When I do the same thing in Excel 2000, 3 column appear and this is the desired result. How do I make 3 columns appear in excel 2003? Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving XLS file as CSV
The program this file is fed to expects a csv file.
Jim May wrote: "I save it in Excel 2003 as csv file" << Why do this? Save as an xls file - Problem solved. "Roman" wrote in message oups.com: I have an xls file with worksheet made up of 3 columns of data. I save it in Excel 2003 as csv file. When I open the csv file, the columns are lumped into one column. When I do the same thing in Excel 2000, 3 column appear and this is the desired result. How do I make 3 columns appear in excel 2003? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a file | Excel Worksheet Functions | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
| saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
