ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   converting csv (commaseparated values) to columns (https://www.excelbanter.com/excel-discussion-misc-queries/71919-converting-csv-commaseparated-values-columns.html)

confused

converting csv (commaseparated values) to columns
 
I have downloaded a csv file with large amounts of data, but all the numbers
are only separated by commas, but i need to assign them to seperate columns
(right now they all are in one). If anyone knows how to do this please
respond quickly, otherwise i have to do it the "hard way"...

Fred Smith

converting csv (commaseparated values) to columns
 
Just open the file. Excel will normally read a CSV file properly, but will also
give you the option of specifying what's in each column.

--
Regards,
Fred


"confused" wrote in message
...
I have downloaded a csv file with large amounts of data, but all the numbers
are only separated by commas, but i need to assign them to seperate columns
(right now they all are in one). If anyone knows how to do this please
respond quickly, otherwise i have to do it the "hard way"...





All times are GMT +1. The time now is 03:09 PM.

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