Sub Decompose()
Dim derlig&, k&
Dim NPr$, t1$, t2$, t3$
On Error Resume Next
With Feuil1
derlig = .Range("A" & Rows.Count).End(xlUp).Row
For k = 2 To derlig
NPr = .Range("A" & k)
If .Range("A" & k) Like "*.*" Or .Range("A" & k) Like "*;*" _
Or .Range("A" & k) Like "*:*" Then
t1 = Split(NPr, ":")(0)
t2 = Split(NPr, ":")(1)
t3 = Split(NPr, ":")(2)
End If
t1 = Replace(t1, t1, "OH")
t2 = Replace(t2, t2, "LA")
t3 = Replace(t3, t3, "LA !")
resultat = "" & .Range("A" & k).Address & ": " & _
Left(t1, Len(t1) - InStrRev(t1, ":")) & ", " & _
Right(t2, Len(t2) - InStrRev(t2, ":")) & ", " & _
Right(t3, Len(t3) - InStrRev(t3, ":"))
MsgBox resultat
Next k
End With
End Sub