Bonsoir Papat,
Je te propose une simple macro avec des lignes de remplacement par rien.
La plage est à adapter...
Sub EffacementLettres()
'Effacement des lettres et autres caractères
Application.ScreenUpdating = False
With Sheets('BASE').Range('A1:A5000')
.Replace What:='a', Replacement:=''
.Replace What:='b', Replacement:=''
.Replace What:='c', Replacement:=''
.Replace What:='d', Replacement:=''
.Replace What:='e', Replacement:=''
.Replace What:='f', Replacement:=''
.Replace What:='g', Replacement:=''
.Replace What:='h', Replacement:=''
.Replace What:='i', Replacement:=''
.Replace What:='j', Replacement:=''
.Replace What:='k', Replacement:=''
.Replace What:='l', Replacement:=''
.Replace What:='m', Replacement:=''
.Replace What:='n', Replacement:=''
.Replace What:='o', Replacement:=''
.Replace What:='p', Replacement:=''
.Replace What:='q', Replacement:=''
.Replace What:='r', Replacement:=''
.Replace What:='s', Replacement:=''
.Replace What:='t', Replacement:=''
.Replace What:='u', Replacement:=''
.Replace What:='v', Replacement:=''
.Replace What:='w', Replacement:=''
.Replace What:='x', Replacement:=''
.Replace What:='y', Replacement:=''
.Replace What:='z', Replacement:=''
.Replace What:='é', Replacement:=''
.Replace What:='è', Replacement:=''
.Replace What:=''', Replacement:=''
.Replace What:=' ', Replacement:=''
'Autant que nécessaire------------
End With
Application.ScreenUpdating = True
End Sub
Cordialement
Bernard