Export to Formatted Text (.prn) file truncates data

D

Dave P.

When I save the excel file as PRN file (text file) the
data is truncated on the right. Not all the columns are
being exported. Does anyone know how to fix this problem?

Thanks
 
D

Dave Peterson

First, excellent choice in names and initials!

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