LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bin
 
Posts: n/a
Default .csv file Multiple columns of data in single Cell

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.6926 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 same 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 PC is
same(Microsoft Excel same).
(2) Is there any option/setting in Excel that is influencing this?
(3) Last but not the least, how do I fix it?

Solutions tried:
Look in Regional and Language options in
the Control Panel of Windows. Select "Customize" on the Regional
Options tab (Windows 2000 Professional), and see whether the "List
Separator" on the other PC is something other than a comma. (List Separator
is comma character in my PC).
so, this solution is not help ful for me.

Hope you guys have a solution to this. Thanks.
Bin.
 
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
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
Viewing data from one column within one single cell ? MAC Excel Discussion (Misc queries) 3 February 22nd 06 05:29 PM
Multiple sheets as data for a single sheet Newbie1092 Excel Worksheet Functions 1 December 19th 05 05:20 PM
How do I copy data in single cell format to a merged cell format Paul Excel Discussion (Misc queries) 1 June 27th 05 11:00 AM
how do i reference data in a file with the fname in another cell? jhlrtn Excel Worksheet Functions 1 May 23rd 05 11:11 PM


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

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"