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!!