Earl Kiosterud's free TEXTWRITE add-in should(will) do what you want.
http://www.smokeylake.com/excel/text_write_program.htm
Gord Dibben MS Excel MVP
On 5 Dec 2006 10:11:28 -0800, "carley465" wrote:
I have a spreadsheet that I need to convert to Ascii file format that
contains things such as names, addresses, ss# and Pledge Amounts. The
record length can't be more than 356 and each of the fields has a
different file format, and length. Not sure how to go about doing this.
Can I do it in excel? Or do I need another program to do this?
Thanks.