Excel getting data summary

[bala06]

Dear Excel Users

I would like to get the summary data from the excel sheet.

For example my data looks like this:

355 355-hydrogen-bond-frame.dat.c.d.lw 355-hydrogen-bond-frame.dat.c.d.pw [(4714, 'UNK', 'X 900B', 45350, 'SPC', 'X6695G', 45350, 'SPC', 'X6695G', 3852, 'ASN', 'A 344B'), (4714, 'UNK', 'X 900B', 45350, 'SPC', 'X6695G', 45351, 'SPC', 'X6695G', 3849, 'ASN', 'A 344B'), (4714, 'UNK', 'X 900B', 62468, 'SPC', 'X3071G', 62469, 'SPC', 'X3071G', 2640, 'THR', 'A 220B'), (4714, 'UNK', 'X 900B', 62468, 'SPC', 'X3071G', 62469, 'SPC', 'X3071G', 2652, 'ASN', 'A 221B')]


I'm expecting output as 355 SPC X6695G ASN344, SPC X6695G ASN344, SPC X3071G THR220, SPC X3071G ASN221

I'm having huge data like this. Is it possible to get the summary like this.
I'm not a macro expert for programming.

I'm attaching the copy of data for your reference.

Kindly advice.

Many Thanks
Balaji

 

[GlennUK]

What are the specific rules that are to be applied to the data to get that summary? You seem to want people to guess the rules based on your example .... I don't think that's a good idea.

 

[bala06]

Dear Excel user

In the data there are four brackets () and from the each brackets i have to get last five text values (from the right).

Example data

355 355-hydrogen-bond-frame.dat.c.d.lw 355-hydrogen-bond-frame.dat.c.d.pw [(4714, 'UNK', 'X 900B', 45350, 'SPC', 'X6695G', 45350, 'SPC', 'X6695G', 3852, 'ASN', 'A 344B'),
(4714, 'UNK', 'X 900B', 45350, 'SPC', 'X6695G', 45351, 'SPC', 'X6695G', 3849, 'ASN', 'A 344B'),
(4714, 'UNK', 'X 900B', 62468, 'SPC', 'X3071G', 62469, 'SPC', 'X3071G', 2640, 'THR', 'A 220B'),
(4714, 'UNK', 'X 900B', 62468, 'SPC', 'X3071G', 62469, 'SPC', 'X3071G', 2652, 'ASN', 'A 221B')]


And expecting the output as 355 SPC X6695G ASN344, SPC X6695G ASN344, SPC X3071G THR220, SPC X3071G ASN221.

Many Thanks
Balaji