Multiple occurrences of a character on a single cell to be copied

Hi,

Need your help on this:

I have the following text in Cell A1:

M4.CTC.VA03.Verify Sales Documents.v2 [14294];
M4.CTC.VK11.Create List Price By Customer Groups.v1 [6317];
M4.CTC.VA03.Verify Sales Documents.v2 [14295]

I would like to copy the following in Cell A2:

[14294]; [6317]; [14295]

There are thousand of rows and each row has multiple lines of text. some has 2 lines some has 10...

Please help!!

Thanks for replying Special-k. However, I am getting error on line 17 Column 1 i.e. where the code says:

l = Left(l, Len(1) - 2)

I have copied your code and pasted it as you have explained.