Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Excel spreadsheet to Ascii file format
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Excel spreadsheet to Ascii file format
Carley
If you're looking for a fixed width text file then set the column widths to what you want, e.g 10 characters set the width to 10 (even if this appears to truncate some characters), now save as a space delimited file (*.prn) via filesave as... Remember you will get warnings that you can only save single sheets in this format, just say yes to all -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "carley465" wrote in message ps.com... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How do I convert an Excel file to an ASCII file? | New Users to Excel | |||
How do I convert a Publisher 8 file into an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) |