| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stacked Columns - Showing Values | Charts and Charting in Excel | |||
| Fliping the values in columns | New Users to Excel | |||
| Converting Columns to Rows | Excel Worksheet Functions | |||
| Totalling values across columns | Excel Worksheet Functions | |||
| Creating a chart with values from two columns | Charts and Charting in Excel | |||
Linear Mode
