Public sub Decoupe() indeXx = 0 For x = 1 To Len(Text1) If InStr(x, Text1, ",") = 0 And x > 0 Then GoTo fin Text(indeXx) = Mid(Text1, x, InStr(x, Text1, ",") - x) x = InStr(x, Text1, ",") indeXx = indeXx + 1 Next x Exit Sub fin: Text(indeXx) = Mid(Text1, x, Len(Text1) - x + 1) End sub