Exporting Excel Spreadsheet to a Space Delimited File

[tvcv3023]

I am trying to export a file from Excel to a space delimited text forma
(.prn), and the spreadsheet contains about 530 characters per row. Whe
I try to save this as a .prn file, it wraps all data past the 240t
character, to the next line.

Is there a way to export a file from Excel to a space delimited tex
format without it wrapping?

Any help would be appreciated.

Thanx,
T

 

[Dave Peterson]

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]

 

[tvcv3023]

Thanks for the help Dave - I'll try that.

T