How can I create an ASCII file with double quotes around each field?

[CJN]

I need to convert Excel files to ASCII files with commas as
delimiters. That part is easy.

The problem is that I need each field to be surounded by double
quotes.

Here is an example of what my ASCII output needs to look like:

"smith","robert","15","elm","street"
"jones","robert","111","main","avenue"

Can anyone suggest a solution on how I can convert my excel file to
ASCII output as shown in my example?

thanks very much!

 

[Guest]

I can get the data into the correct format but then you will need to take it from there.
(If you can't save as an ASCII from Excel, you may be able to copy the data and paste
into "NOTEPAD" or some other appropriate program and save from there)

Insert a blank column between each data field. The last name is now in cell B1.
Insert the following into the respective blank cells:

Cell A1 ""
Cell C1 "","
Cell E1 "","
Cell G1 "","
Cell I1 "","
Cell K1 ""

Copy all of these down for all data rows.

In cell L1 enter the formula =A1&B1&C1&D1&E1&F1&G1&H1&I1&J1&K1
Copy this formula down for all data rows.

Select all the data now in column L

Copy>Paste Special>Values

Column L now contains the data in the format that you need.

Happy New Year from Ohio

 

[BrianB]

Not easy. Try this link :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;123183&Product=xlw97

 

[John Taylor]

Try the excellent "Text Write" program written by Earl Kiosterud, which is
available from the following web site run by Tushar Mehta:

http://tushar-mehta.com/index.html?http://tushar-mehta.com/excel/

It does exactly what you want.

Cheers,

John