ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CSV loading incorrect (https://www.excelbanter.com/excel-worksheet-functions/182729-csv-loading-incorrect.html)

Washeacrim

CSV loading incorrect
 
When A CSV file is loaded into Excel 2003 it in a text format ie within in
the first column followed by commas.
How do it get CSVs to load so it nloads has a excel spreadsheet format ie in
individual columns

ryguy7272

CSV loading incorrect
 
Data Import External Data Import Data then click on file.
Open Delimited Next Comma Next Finish OK.

Regards,
Ryan---
--
RyGuy


"Washeacrim" wrote:

When A CSV file is loaded into Excel 2003 it in a text format ie within in
the first column followed by commas.
How do it get CSVs to load so it nloads has a excel spreadsheet format ie in
individual columns


David Biddulph[_2_]

CSV loading incorrect
 
If it didn't treat the commas as delimiters, then I wonder whether the
Windows Regional Options (accessed via Control Panel) are specifying the
list separator as semi-colon, rather than comma?
--
David Biddulph

"ryguy7272" wrote in message
...
Data Import External Data Import Data then click on file.
Open Delimited Next Comma Next Finish OK.

Regards,
Ryan---
--
RyGuy


"Washeacrim" wrote:

When A CSV file is loaded into Excel 2003 it in a text format ie within
in
the first column followed by commas.
How do it get CSVs to load so it nloads has a excel spreadsheet format ie
in
individual columns





All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com