When converting an Excel formatted file to CSV (per a bank's
specifications), I'm having trouble with the extra commas that are
being inserted into certain parts of the CSV file. In the Excel file
there are header, detail and trailer records. In the detail record,
there are 17 columns of data in the excel file. In the header and trailer
record there are 4 columns of data in the excel file. When I save the XL file
to CSV and open in Notepad, the header and trailer records will
automatically insert 13 additional commas (to match the detail info).
I need to not have the commas in the CSV file per bank specifications.

How do I remove these commas in the header and trailer records,
without manually opening the CSV file and deleting them (this would
comprise the process). Is there a workaround in Excel, or perhaps a
script can be written (naive to this too)? The info as to start in
Excel and be saved into CSV, and those commas have to be removed in
the header and trailer records.

Help!

instead of using notepad use notepad ++ 
( http://notepad-plus.sourceforge.net/uk/site.htm )

with notepad ++ you can create a macro similar to excel which will
remove the extra commas,

or

in excel, create a macro that 
moves the header to a separate sheet
moves the footer to a separate sheet

so you end up with,
sheet 1 - header
sheet 2 - detail
sheet 3 - footer

export each sheet to its own csv file

create a bat file with the following lines :

-------------
copy header.csv+detail.csv+footer.csv finalfile.csv
exit
-------------

run the bat file to add all 3 parts back together,
job done.

hope this works for you,
Shaun.