Exporting from Excel to Space Delimited File

[Guest]

I am trying to export an Excel sheet to a space delimited file of 539 characters but it it wrapping the rows in the text file. Does anyone know how to resolve this? (Other than using Access)

 

[Paul Falla]

If you are viewing the text file with Notepad, check to
see that you have the word wrap function switched off
(Format/WordWrap)

Hope thhis helps

Paul Falla

-----Original Message-----
I am trying to export an Excel sheet to a space delimited

file of 539 characters but it it wrapping the rows in the
text file. Does anyone know how to resolve this? (Other
than using Access)

 

[Guest]

Word wrap is definately off . I have viewed the file in Wordpad also. I am thinking there may be a limitation within the Excel export function. I may trying filling the gaps between fields with spaces (" ") using a short macro, then exporting as regular text
----- Paul Falla wrote: ----

If you are viewing the text file with Notepad, check to
see that you have the word wrap function switched off
(Format/WordWrap

Hope thhis help

Paul Fall

-----Original Message----
I am trying to export an Excel sheet to a space delimited

file of 539 characters but it it wrapping the rows in the
text file. Does anyone know how to resolve this? (Other
than using Access)

 

[Dave Peterson]

Are you saving as a .prn file? The limit for that is 240 characters per line
before it starts wrapping lines.

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]