Sub Decoupe()
Dim i As Long, j As Byte, Tablo, Tabfin, Aut, Det, NomPre, x As Byte
With Worksheets("Feuil1")
Tablo = .Range("A2:A" & .Range("A" & Rows.Count).End(xlUp).Row)
ReDim Tabfin(1 To UBound(Tablo), 1 To 8)
For i = LBound(Tablo) To UBound(Tablo)
x = 0
Aut = Split(Tablo(i, 1), ";")
For j = 0 To UBound(Aut) - 1
Det = Split(Aut(j), ",")
NomPre = Split(Det(0), "(")
Tabfin(i, 1 + x) = Det(0)
Tabfin(i, 2 + x) = NomPre(0)
If UBound(NomPre) = 1 Then Tabfin(i, 3 + x) = Left(NomPre(1), Len(NomPre(1)) - 1)
Tabfin(i, 4 + x) = Det(1)
x = x + 4
Next
Next
.Range("B2").Resize(UBound(Tabfin), 8) = Tabfin
End With
End Sub