Bonsoir tout le monde,
Un essai....
Sub test_tb()
Dim tablo, tabloR(), k%, i%
With Sheets("fichier_client (9)")
tablo = .Range("A1").CurrentRegion
k = 0
For i = 2 To UBound(tablo, 1)
If tablo(i, 1) <> "" Then
ReDim Preserve tabloR(1 To 3, 1 To k + 1)
If Not IsNumeric(tablo(i, 1)) Then
'tabloR(1, 1 + k) = val(Trim(Mid(tablo(i, 1), 1, 2)) & Trim(Mid(tablo(i, 1), 9, 17)))
tabloR(1, 1 + k) = Val(Trim(Mid(tablo(i, 1), 1, InStr(1, tablo(i, 1), "_") - 1)) & Right(Trim(Split(tablo(i, 1), "|")(1)), Len(Trim(Split(tablo(i, 1), "|")(1))) - 1))
Else
tabloR(1, 1 + k) = Val(tablo(i, 1))
End If
tabloR(2, 1 + k) = tablo(i, 2)
tabloR(3, 1 + k) = tablo(i, 3)
k = 1 + k
End If
Next i
.Range("A1").CurrentRegion.Offset(1, 0).ClearContents
On Error Resume Next
.Range("A2").Resize(UBound(tabloR, 2), 3) = Application.Transpose(tabloR)
.Columns("A:A").NumberFormat = "0#"" ""##"" ""##"" ""##"" ""##"
End With
End Sub
Cordialement,