Save as Non-Delimited Text File


Posted by K Wobus on March 23, 2001 12:45 PM

I need to save an excel spreadsheet as a text file, which will then be fed into a mainframe program. It should not be delimited, so the data will just run together. I have tried all of the available text options and end up with spaces delimiting my file equal to the column width (it appears at least). All of my columns will have fixed length data (column 1=4 bytes, column 2=6 bytes, etc.). I have tried fitting my column to the size of the data, but this also doesn't seem to work--when I save the file it still adds spaces to the end of each 'column'. Any ideas?

Posted by mseyf on March 23, 2001 1:02 PM

try creating a new sheet that concatenates all the columns from the old sheet into one column on the new sheet. i.e. in cell A1 of the new sheet enter

=sheet1!a1&sheet1!b1&sheet1!c1&sheet1!d1....

then save the new sheet.

HTH

Mark



Posted by Aladin Akyurek on March 23, 2001 1:11 PM

Watch out for 255 chars limit.