HI,
I am importing a txt file using the text import wizard, myfiles have 820 columns (Column AEN)
I need all data to be imported as TEXT.
The issue I am finding and have no explanation for is atstep 3 of the text import wizard,
I select TEXT and select all columns.
The issue is in the data preview it stops at column 363(Column MZ).
When I then import all columns export as expected but onlyup to column 363 are TEXT format, the rest are general format.
Was wondering if anyone has come across this and if this isa known bug in Excel 2013?
Is there a limit to the number of columns you can applyformatting to when importing?
I am importing a txt file using the text import wizard, myfiles have 820 columns (Column AEN)
I need all data to be imported as TEXT.
The issue I am finding and have no explanation for is atstep 3 of the text import wizard,
I select TEXT and select all columns.
The issue is in the data preview it stops at column 363(Column MZ).
When I then import all columns export as expected but onlyup to column 363 are TEXT format, the rest are general format.
Was wondering if anyone has come across this and if this isa known bug in Excel 2013?
Is there a limit to the number of columns you can applyformatting to when importing?
