Excel to space delimited txt file with 900 characters

[ginny777]

Hi! I am a newbie and have searched for an answer to my question on the messages boards, but don't see one that quite fits.

I will be receiving a file in Excel which contains a column for the first name, last name, a date and an email address (it could possibly have more - street address, etc.- but this is the norm). This file will need to be turned into a space delimited .txt file with no tabs. The text file will need 42 "columns" each a specific length for a total of 900 characters in each row. A lot of the columns will be blank, but the spaces must be there, and some of the columns will need to be populated with the same default data in each cell.

Some help with this would be greatly appreciated, right now I'm doing this by hand, but we will have thousands in upcoming files, and it will be too time consuming!

Extra help - one of the columns will need to be a ascending number sequence - 11 characters and prepadded with zeros (00000000001,00000000002 etc.), and the date column will need to be in CCYY-MM-DD (2011-04-08).

Ginny

 

[ginny777]

Ok, I got past that. Column "m" should have actually been "n".

Now I get another: run time error '5': invalid procedure call or argument.

At this line:

Spacer = Left_Side & Space(Total_Length - (Len(Left_Side) + Len(Right_Side))) & Right_Side

 

[RSXchin]

please email one of your spreadsheets so I can tool with it. This is very difficult if I can't see it.

 

[ginny777]

OK, Thanks for trying.
Ginny

 

[ginny777]

Sure, how do I email you?

 

[RSXchin]

crxchin@juno.com

note: this is my spam email. every guy has this.

 

[ginny777]

Sent.

 

[RSXchin]

sorry, i didnt get it. is it over 2 megs?

check the address

CRXCHIN@JUNO.COM

 

[ginny777]

For some reason it will not leave my outbox.

I'll try another account.

 

[ginny777]

Sent