| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Downloaded CSV Data to Automatically Appear in Separate Columns
Hi
When our Excel 97 users download data from a particular site in CSV format the data is not separated automatically into columns. They have to manually run the Text to Columns feature. Is there a setting / process that will allow the data to automatically format into columns upon download? This only seems to impact our 97 users. Thanks in advance Monk |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Downloaded CSV Data to Automatically Appear in Separate Columns
I'd check to see if the windows list separator (in the control panel|regional
settings applet) is the same as what's used in the .CSV file for the offending pc's. Monk wrote: Hi When our Excel 97 users download data from a particular site in CSV format the data is not separated automatically into columns. They have to manually run the Text to Columns feature. Is there a setting / process that will allow the data to automatically format into columns upon download? This only seems to impact our 97 users. Thanks in advance Monk -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to Automatically Re-Categorize a Downloaded Internet Spreadsheet | Excel Discussion (Misc queries) | |||
| Separate data into two columns | Excel Discussion (Misc queries) | |||
| Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
![Monk[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
