I have multiple text files with 4 different subjects. Can any one please tell me how to i merge in 4 mega text files and 4 mega Excell sheets. For example:

Senior_Citizen_/_Medicaid Discount-11-10-2006

For all Direct Debit subject i need one jumbo Direct Debit text file. After each subect there is a hyphen and then a number. I dont need any thing after hyphen

Direct Debit - 976583
Recur Credit Card - 590287
Name Change Form - 931943
Senior Citizen / Medicaid Discount - 975836

Thanks in advance.