=CHOISIR(COLONNE(A1);GAUCHE($A1;2); DROITE($A1;3))
For i = 1 To Range("A65000").End(xlUp).Row
Range("B" & i) = "'" & Left(Range("A" & i), 2)
Range("C" & i) = "'" & Right(Range("A" & i), 3)
Next i
For i = 1 To Range("A65000").End(xlUp).Row
Range("B" & i) = Left(Range("A" & i), 2)
Range("C" & i) = Right(Range("A" & i), 3)
Next i
Bonsour®
Dim Cellule1 As Range
For Cellule1 = 1 To Range("A65000").End(xlUp).Row
Sub Découpe()
Dim R As Range
For Each R In Range("A1", [A1000].End(xlUp))
R(1, 2) = Left(R, 2)
R(1, 3) = Right(R, 3)
R(1, 3).NumberFormat = "000"
Next
End Sub
=GAUCHE(TEXTE(A2;"00000");2)
salut
, la déclaration n'est valable pour la suite.
Code:Sub Découpe() Dim R As Range For Each R In Range("A1", [A1000].End(xlUp)) R(1, 2) = Left(R, 2) R(1, 3) = Right(R, 3) R(1, 3).NumberFormat = "000" Next End Sub
Sub Découpe()
Dim R As Range
For Each R In Range("A1:a10000")
R=Application.trim(R)
R.Offset(0, 1) = Left(R, Len(R) - 3)
R.Offset(0, 1).NumberFormat = "00"
R.Offset(0, 2) = Right(R, 3)
R.Offset(0, 2).NumberFormat = "000"
Next
End Sub
Sub Découpe()
Dim R As Range
For Each R In Range("A1:A1000")
R(1, 2) = Int(Val(R) / 1000)
R(1, 2).NumberFormat = "00"
R(1, 3) = Right(R, 3)
R(1, 3).NumberFormat = "000"
Next
End Sub
Function CodPos3(x)
CodPos3 = Right(x, 3)
End Function
Function CodPos2(x)
CodPos2 = Format(Replace(x, CodPos3(x), ""), "00")
End Function