exporting Excel spacing is off 1

[KevinSwe]

I have an Excel 2003 ss that has the columns formatted to certain widths. When I save as the spacing gets lost and columns jam up next to each other. When I look at the file in wordpad it should be columns of data.

I have tried every possible "save as" in Excel. Any suggestions?
Thank you,
Kevin

Nuttin's so simple you can't complicate it.

 

[SkipVought]

Hi,

Save you file as a .prn formatted text space delimited.

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]

 

[KevinSwe]

The file is 650 characters and when I use the prn it cuts it off. I tried changing the paper size and the max it will let me go is around 350.

The reason I need 650 is that I am ul the file to an AS400 and it is expecting the file a certain way.

Thank you,
Kevin Sweeney

 

[SkipVought]

Do you mean that a single column is 650 long or is the entire row 650 long?

Please post a sample row of data (copy 'n' paste)

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]

 

[SkipVought]

I am referring to SOURCE data to post.

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]

 

[KevinSwe]

The entire row is made up of 43 columns.

Nuttin's so simple you can't complicate it.

 

[SkipVought]

I'm waiting...............

Skip,
[sub]
[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE! [/sub]

 

[KevinSwe]

Due to the sensitive nature of the data I can't send anything. However, our programmer showed up and the problem is the FDF needed corrected. That being done the file is uploading correctly.

Nuttin's so simple you can't complicate it.