Sub ParCommoditéOnPeutEnvisagerUneMacro()
Dim t, u
t = Array(Array(1, 9), Array(2, 1)): u = Array(Array(1, 1), Array(2, 1)): Application.DisplayAlerts = 0
With Selection
.TextToColumns _
Destination:=.Offset(, 1).Item(1), DataType:=1, Other:=-1, OtherChar:=")", FieldInfo:=t
.Offset(, 1).TextToColumns _
Destination:=.Offset(, 1).Item(1), DataType:=1, Other:=-1, OtherChar:="-", FieldInfo:=u
End With
End Sub