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 quot;hard wayquot;...
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,
Fredquot;confusedquot; gt; wrote in message
...
gt;I have downloaded a csv file with large amounts of data, but all the numbers
gt; are only separated by commas, but i need to assign them to seperate columns
gt; (right now they all are in one). If anyone knows how to do this please
gt; respond quickly, otherwise i have to do it the quot;hard wayquot;...
- Oct 05 Fri 2007 20:40
converting csv (commaseparated values) to columns
close
全站熱搜
留言列表
發表留言