Bonjour,
Une proposition VBA !?
Cdlt.
Public Sub Test()
With ActiveSheet
With .Columns(1)
.TextToColumns Destination:=.Cells(1), _
DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 2), Array(11, 9), Array(22, 2), Array(52, 9)), _
TrailingMinusNumbers:=True
End With
.Cells(1).CurrentRegion.EntireColumn.AutoFit
End With
End Sub