max no. of columns

  • Thread starter Thread starter mfp1973
  • Start date Start date
M

mfp1973

I need to import som data to Excel (.txt). My problem is that the no of
columns are 300, and Excel seem to have a 256 column limit- does
anybody know how to solve this problem.

michael
 
Michael,

There is no way to get more than 256 columns per sheet.

Options are:
- spread across multiple sheets
- transpose the data (columns to rows)
- choose another product.


Sorry!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
One way.. Open a new excel file, do data>import external data, select the
text file and
go through the steps, it will ask you where you want to import this and that
the file cannot be imported
bla bla.. Import 256 columns to sheet1, now select A1 in sheet2, repeat the
procedure but in step 3
select the first 256 column, click in the first column, scroll to the 256th
column, hold down shift and click it, then select do not import (skip),
click finish and the rest of the columns will be imported to A:An in sheet2.
 
Back
Top