Text File for creating report

(It is some lengthy but PLEASE help, i really need it and THANKS in advance
I want to convert a text file into excel sheet

and then sort that file according to one particular column having three diff values

this data (full rows) has to go to three reports on one sheet according to that column

my text file is as under:

1123601714000730300000000100000000520500140022302
1123601814000730200000000100000000057800140240302
1150392014000730300000000100000003396100140240302
1150392114000730200000000100000000377400140025302
1189906014000730200000000100000000329400140211302
1189906114000730200000000100000000036600140024303

and this file may have rows from minimum to max say 1000 rows


i have to break this data rows as under
11 236017 140007303 0000000010 00000005205 00 140022302

now first two digits (11) have no value

next 6 digits are to go in column B

then next 9 digits have to go into column A (these 9 digits will always be either of 140007302 or 140007303 or 140007304

next 10 digits are again of no value

next 11+2 digits are amount (Rs. and Paise) and have to go in column C in 5205.00 format. (Left zeros to be removed)

last 9 digits have to go into column D

when the sheet is prepared this way with column A,B,C & D
i have to sort it on column A
140007302
140007303
140007304
these are the codes of separate departments.

now finally the department wise 3 reports are to be prepared showing column B,C & D

like this:-
Department 140007302

B C D
236566 --- 5205.00 --- 140022302
656565 --- 10000.00 --- 140023303
656564 --- 500.11 --- 140240302
(all rows having 140007302 in column A to come here)

Then next report for Department 140007303

and then for Department 140007304

I hope you guys understand my problem and will surely provide help for this.
Function method or VBA method.........both may be suggested please