MyTab() = Split(val, " ") Cells(ligneDef, 3).Value = MyTab(4) While valTest <> "Fax" valTest = Left(Cells(compt, 2), 3) val = Cells(compt, 2) If valTest "Tél" Or valTest "Fax" Then Set MyTab() = Nothing MyTab() = Split(val, ":") val = Replace(MyTab(1), ".", "") End If valInsr = valInsr & "/" & val compt = compt + 1 Wend