Sub SéparerNew()
With ActiveSheet
Set Rg = .Cells(9, 3).Resize(.Cells(.Rows.Count, 3).End(xlUp).Row)
End With
Rg.Replace What:=" - ", Replacement:="§", LookAt:=xlPart
Application.DisplayAlerts = False
Rg.TextToColumns Destination:=Rg.Cells(1).Offset(0, -1), DataType:=xlDelimited, _
Other:=True, OtherChar:="§", _
FieldInfo:=Array(Array(1, 1), Array(2, 1)), DecimalSeparator:="."
Application.DisplayAlerts = True
End Sub