Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel truncates text file
Message
From
16/02/2001 19:26:12
Fausto Garcia
Independent Developer
Lima, Peru
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Excel truncates text file
Miscellaneous
Thread ID:
00476920
Message ID:
00476920
Views:
51
Hi,

I have an Excel worksheet with 20 columns, and need to save it in text format. When I save it as text with delimiters (to a .prn file) the resulting file has the last 3 columns saved at the bottom of the file, as if a right boundary had been reached. It looks like this:

A B C ... O P
1 1 1 ... 1 1
2 2 2 ... 2 2
...
n n n

Q R S
1 1 1
2 2 2
...
n n n

while I expected to get

A B C ... R S
1 1 1 ... 1 1
...
n n n ... n n

Any ideas on how to solve this?

TIA,
Solo se que nada se

Fausto J. Garcia Pino - MCSD.NET
.NET, Oracle, Tronador & Fondismo!
Reply
Map
View

Click here to load this message in the networking platform