View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
slipstrm slipstrm is offline
external usenet poster
 
Posts: 2
Default Saving txt files with quotation mark delimiters

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