=GAUCHE(A1;CHERCHE("j";A1;1)-1)
=DROITE(A1;NBCAR(A1)-CHERCHE("j";A1;1))
Private Sub CommandButton1_Click()
[B1] = Mid(Range("A1"), 1, InStr(1, Range("A1"), "j") - 1)
[C1] = Mid(Range("A1"), InStr(Range("A1"), "j") + 1)
End Sub
Private Sub CommandButton1_Click()
Dim Chaine As String
Chaine = [A1]
[B1] = Mid(Chaine, 1, InStr(1, Chaine, "j") - 1)
[C1] = Mid(Chaine, InStr(Chaine, "j") + 1)
End Sub