Text to columns

[vicedo]

Hi guys, i have informations such as these

			MR EXCEL & CO LTD.
LAGOS DISTRICT			ACCOUNT STATUS REPORT
01/28/2015					BILLING MONTH: JAN 2015	PAGE: 001
08:45:15			STATUS CODE = 02
ACCOUNT NUMBER	NAME	ADDRESS	BILL DATE	PMT DATE	PMT AMOUNT	BALANCE
01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70
01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70
01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70
01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70

<tbody>
</tbody>

These are notepad files that have been pasted into excel and all i want is for excel to look through my sheet and delete the Account Number, name, address, bill date, pmt date, pmt amt, balance and any other information up to MR EXCEL & CO LTD. then leave just these infos and split them into columns like this

01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70
01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70
01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70
01/01/11/2015-01	EDOZIE VICTOR	PENNSYLVANIA DISTRICT	30/07/2014	16/06/2011	2,000.00	206,367.70

<tbody>
</tbody>

I guess VBA can help in this situation. Thanks in anticipation

 

[konew1]

if it is a regular task then I would go with VBA. If it is once only I would
1, insert new column A and number the rows from A1 to the end of your data, then
2. Sort the data by column B. This will put all of the account numbers together.
3. Delete the rows with unwanted headers etc. Some will be at the top and some will be below the wanted data,
4. Sort by the temporary numbers in column A to return data to original sequence.
5. delete temp column A

 

[vicedo]

It has become a regular task for me

 

[vicedo]

i currently have about 50 folders that comes in the same format

 

[konew1]

In that case you probably need vba. Someone can help but you need clearly explain how to recognise the lines you want to keep