Isolate data inside [ ] ; and ,

Hi there,

I have a format like this:

ID	Author Address
1	[Amaya-Amaya, J.; Calvo-Paramo, E.; Calderon-Paez, A.; Torralvo-Morato, G.; Calixto, O. J.; Mantilla, R. D.; Anaya, J. M.; Rojas-Villarraga, A.] Univ Rosario, Sch Med & Hlth Sci, Ctr Autoimmune Dis Res CREA, Bogota, Colombia.

I need to Isolate the data into columns, but giving priority to the first 'sentence' (everything inside the commas ,) after the ], the authors (the names inside [ ] ), and the countries (the very last word)

In order to get this:

1	Amaya-Amaya, J.	Univ Rosario	Colombia.
1	Calvo-Paramo, E.	Univ Rosario	Colombia.
1	Calderon-Paez, A.	Univ Rosario	Colombia.
1	Torralvo-Morato, G.	Univ Rosario	Colombia.
1	Mantilla, R. D.	Univ Rosario	Colombia.
1	Anaya, J. M.	Univ Rosario	Colombia.
1	Rojas-Villarraga, A.	Univ Rosario	Colombia.

How can I achieve this? I really need this with urgency, but have no idea on how to do it

Certainly I don't care if the other columns remain in the result sheet, as long as I can isolate the information for those three, I can rearrange the format later on...

There are some rows where there's more than "one country", which would look like:
[Name; Name; Name;] Data, Data, Data, Country. [Name; Name; Name;] Data, Data, Country.

But it is still the very last word that I need as the country...

Attached is an example Book

Hello,

This is similar to one of your previous post...
Try this code :

Please Login or Register  to view this content.

You are welcome...
Thanks for the rep.