View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Convert Excel spreadsheet to Ascii file format

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.