Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple columns of data saved in a CSV file appears in a single c
Summary:
The problem is that when I export data from an application to a CSV file and open it, it is appearing differently on the different PCs which are having the same versions of Excel (Microsoft Excel 2000 9.0.7924 SP-3). Issue Description: On one PC, when the saved .csv file is opened, the data in it is spreading a record record containing some 4 fields across 4 different cells/columns. This is fine and is what is required for me. While on the other PC, when the saved .csv file is opened, the entire record is inserted into a SINGLE CELL/COLUMN containing those 4 values separated by a comma. But here as well, I would want a record to spread across different columns/cells. Hence I would like to know the answers to any of the below questions: (1) why is there a difference in the appearance while the Excel versions are exactly the same? (2) Is there any option/setting in Excel that is influencing this? (3) Last but not the least, how do I fix it? Hope you guys have a solution to this. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
File Error: Data May Have Been Lost | Excel Discussion (Misc queries) | |||
Matching data in multiple columns | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Lookup Data in Several Columns | Excel Worksheet Functions |