SAVE IN TEXT FORMAT GIVES TABLE IN TWO PARTS

H

HANS MELANDER

i NEED A TEXT FILE WITH FIXED LENGHTS OF FIELDS, TABS NOT
ALLOWED.
The excel sheet with 6500 rows is saved as first 6500 rows
with first some 30 colums,
balance 15 colums is then put in rows 6501 to 13 000.

How can I get my text file with full lines from 45 columns?
 
D

Dave Peterson

There's a limit of 240 characters per line when you save as .prn files.

You have a few choices (try against a copy of your worksheet):

I'd either concatenate the cell values into another column:

=LEFT(A1&REPT(" ",5),5) & LEFT(B1&REPT(" ",4),4) & TEXT(C1,"000,000.00")

(You'll have to modify it to match what you want.)

Then I'd copy and paste to notepad and save from there. Once I figured out that
ugly formula, I kept it and just unhide that column when I wanted to export the
data.

If that doesn't work for you, maybe you could do it with a macro.

Here's a link that provides a macro:
http://google.com/[email protected]
 
Top