converting excel spreadsheet to formatted text space delimited

[rsims]

I have an excel spreadsheet with columns A - AC and I need to save it in formatted text space delimited. When I do save as and select formatted text space delimited the file wraps at 255 characters. Is there anyway to get around this? I need the entire row to be on one line followed by the next row on the next line.

Thanks,
rsims

 

[dsi]

Each row is on one line. Turn Word Wrap off on your notepad/wordpad application.

 

[rsims]

dsi suggestion didn't work.

The test spreadsheet contains 10 rows, 26 columns (A - AC) in the space delimited file created from excel. The first 10 rows appear with columns A - P and then after those same 10 rows with columns P - AZ appear.

See sample below:

001 92859156R10 MIKASINOVGEOR-0000 20001212
001 92859156R10 APGAR----ARTHN0000 20001213
001 92859156R10 ANDERSON-JOYCN0000 20001215
001 92859156R10 DITTBERNEGEOR-0000 20001124
001 92859156R10 BETCHER--JOANA0000 20001128
001 92859156R10 SCARAMOZZRALPL0000 20001212
001 92859156R10 LARRISON-CHARB0000 20001205
001 92859156R10 THAXTON--SYBES0000 20001201
001 92859156R10 BENEDETTAELIZ-000 20001206
001 92859156R10 SHERBET--NATHG0000 20001130
20010122MIKASINOVGEOR-0000
20010122APGAR----MILD-0000
20010122ANDERSON-JOYCN0000
20010122DITTBERNESTACV0000
20010122BELCHER--JOANA0000
20010122SCARAMOZZMARIH0000
20010122SCHREINERMARYL0J00
20010122SWAIN----CLA1W000
20010122BENEDETTAGENEJ0000
20010122SHOWERS--GLORJ0000

Any other suggestions?

 

[dsi]

That definately looks strange. I am not sure why it would behave like that. It works fine for me. I filled in columns A-AC, rows 1-10 with the value abcdefghijkl. When I save as a space delimeted file (*.prn) and open it with notepad, it works fine. Just Shift-Right Click the file and Open With -> Notepad. Turn Word Wrap off to view the file as it is written. What application are you opening the .prn file with?

 

[JohnMRossi]

I am having the same problem exporting a prn file in excell. My file also wrap at 255 characters. any new suggestions?