Saving txt files with quotation mark delimiters

[slipstrm]

I have a fixed width data file and need to convert it to a csv file with
quotation marks and commas a delimiters. I thought there was an easy way to
do this in Excel. I open the file with excel and I can define fields but I
cant figure out a way to save the data with quotation marks around the files
separated by commas. Is there any easy way to do this. I have 8 files to
do this with containing about 20-25K records each.

Thanks

 

[Sheeloo]

See http://support.microsoft.com/kb/291296 for a macro...

 

[slipstrm]

Thank you sheeloo.

See http://support.microsoft.com/kb/291296 for a macro...