Separate files according to subject into Excell
Hi:
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:
Direct_Debit-11-10-2006
Recur_Credit_Card-11-10-2006
Name_Change_Form-11-10-2006
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
Thank You.
|