Excel to text

[sanlike]

i have a excel file which I want in .txt output.
In EXCEL sheet1 A1 contains number, B1 contains name, C1 contains Amount, D1 contains particulars.

When I run Macro in text file to be created. In text out put I want spacing for A1 data is 14 {the account number varies from 5 digit to 14 digit} B1 30 (name characters may be from 5 to 25), C1 15 & D1 10
EXAMPLE
In Excel
A B C D
1 7895689 SHANKAR 125.90 CASH
2 2568698522 RAJA 12565.00 CHEQUE
3 256 WILLIAM RAJASHEKAR 256865.55 CREDIT CARD

IN TEXT FILE THE OUT PUT SHOULD BE

7895689 SHANKAR 12590CASH
2568698522 RAJA 12565CHEQUE
256 WILLIAM RAJASHEKAR 25686555CREDIT CARD

 

[Greg Truby]

No estoy seguro porqué colocó la presente en el foro para idiomas extranjeras. La voy a mover al foro de inglés.