Sub Remplacer()
Dim c As Range
Application.ScreenUpdating = False
With Columns(1).SpecialCells(xlCellTypeConstants) ' numéro de colonne adapter
.Replace What:="*- ", Replacement:="", LookAt:=xlPart
.Replace What:=" (*)", Replacement:="", LookAt:=xlPart
End With
Application.ScreenUpdating = True
End Sub