Hi all,
I need to import a table from a text file into Excel. The text file has numbers that are delimited by semi-colons. The problem is that there are around 450 columns and excel obviously only allows 256 columns. Fortunately I don't need all of the 450 columns, just around 200 odd of them. So what I need to do is selectively import certain columns.
Each row of the text file is something like this:
2700; 1.8; 0.0; 0.00; 96; 1.8; 96; 13.4; 5.6; 1.00;.........
The first column is the category and the subsequent columns are the data. The columns I need to import are the:
1st (ie the category column), then the 2nd, 5th, 8th, 11th, 14th etc etc (ie only every third column).
Can anyone help me to import this data? Any help would be greatly appreciated!
I am running Excel 2003 with Service Pack 1.
Many thanks
Jon
I need to import a table from a text file into Excel. The text file has numbers that are delimited by semi-colons. The problem is that there are around 450 columns and excel obviously only allows 256 columns. Fortunately I don't need all of the 450 columns, just around 200 odd of them. So what I need to do is selectively import certain columns.
Each row of the text file is something like this:
2700; 1.8; 0.0; 0.00; 96; 1.8; 96; 13.4; 5.6; 1.00;.........
The first column is the category and the subsequent columns are the data. The columns I need to import are the:
1st (ie the category column), then the 2nd, 5th, 8th, 11th, 14th etc etc (ie only every third column).
Can anyone help me to import this data? Any help would be greatly appreciated!
I am running Excel 2003 with Service Pack 1.
Many thanks
Jon