Export to Notepad but keeping blank spaces in the cell?

So you simply need to pad each line of data. Correct? Does the notepad file need to be saved or does this "other" program read directly from a currently opened file.

I have been having lots of 'fun' with this, this morning.
Excel is very annoying.

I am taking addresses from a spreasheet, into a flat file to be run as a batch, to import to them.
The format the 'other' program needs is.
35 chars, 35 chars, 15 chars, 15 chars, 15 chars, 15 chars, 8 chars,

So this has nearly worked,

=A1&REPT(" ",35-LEN(A1)) & B1&REPT(" ",35-LEN(B1)) & C1&REPT(" ",15-LEN(C1)) etc

BUT
It doesn't like it if the first column is blank,
If a number is the first character in a cell.

and sometimes if just brings back #Value for no reason at all.
Excel is very temperamental indeed..

Maybe

=A1&REPT(" ",15-LEN(A1)) & B1&REPT(" ",15-LEN(B1)) & C1&REPT(" ",15-LEN(C1))

So you get it all in one cell.
Then copy and paste special Value onto 2nd sheet, then save to txt file.

VBA Noob

that's just what i put, but you reduced the 35's to 15's.

It wasn't excel anyway.

I had some text in a column, that was larger than 15 chars, so it didn't like it...