I need to save a huge file that is in excel (columns) to an undelimited file
to upload to another program

Seems like a lot will depend on the other program, and how picky it is
when importing data. If you have multiple columns of Excel data, yet
transferred data may have no delimiters, won't that combine or
concatenate mutiple columns into one single very wide column?

So you want to save the file with fixed width fields?

Saved from a previous post:

There's a limit of 240 characters per line when you save as .prn files. So if
your data wouldn't create a record that was longer than 240 characters, you can
save the file as .prn.

I like to use a fixed width font (courier new) and adjust the column widths
manually. But this can take a while to get it perfect. (Save it, check the
output in a text editor, back to excel, adjust, save, and recheck in that text
editor. Lather, rinse, and repeat!)

Alternatively, you could 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.)

Drag it down the column to get all that fixed width stuff.

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/groups?threadm=015...0a% 40phx.gbl

Lori wrote:

I need to save a huge file that is in excel (columns) to an undelimited file
to upload to another program

--

Dave Peterson

Lori,

The Text Write Program at http://www.smokeylake.com/excel/text_write_program.htm will allow
you to specify nothing for the field (column) delimiter. Your worksheet rows will be
written each as one big line in the text file. Or you could specify a space, if needed.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Lori" wrote in message
...
I need to save a huge file that is in excel (columns) to an undelimited file
to upload to another program