View Single Post
  #1  
Old November 10th, 2006, 06:25 PM posted to microsoft.public.access.forms
Anna
external usenet poster
 
Posts: 66
Default 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.