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"... |
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