Separate files according to subject into Excell

[Anna]

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.

 

[Guest]

This newsgroup is for Access, the relational database product. If you are
wanting to merge data into Excel files, you should ask your question in an
Excel newsgroup.