Bonsoir
Pour le même prix 2 macros, à toi de choisir celle qui te plait le plus
Option Explicit
Sub Coupe()
Dim T1, J As Long
Application.ScreenUpdating = False
T1 = Range("B5:B" & Range("B" & Rows.Count).End(xlUp).Row)
For J = 1 To UBound(T1)
T1(J, 1) = Left(T1(J, 1), 8)
Next J
Range("B5").Resize(UBound(T1)) = T1
End Sub
Sub CoupeBis()
Application.ScreenUpdating = False
With Range("C5:C" & Range("B" & Rows.Count).End(xlUp).Row)
.Formula = "=LEFT(B5,8)"
.Value = .Value
.Copy Range("B5")
.ClearContents
End With
End Sub