1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
Sub Sa(Rg As Range) ' Sa = Sans Accent
' Enlève les accents ; ô devient o
Application.ScreenUpdating = False
With Rg
.Replace What:=" ", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, _
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
.Replace What:="'", Replacement:=""
.Replace What:="-", Replacement:=""
.Replace What:="é", Replacement:="e"
.Replace What:="ê", Replacement:="e"
.Replace What:="è", Replacement:="e"
.Replace What:="ë", Replacement:="e"
.Replace What:="ï", Replacement:="i"
.Replace What:="î", Replacement:="i"
.Replace What:="à", Replacement:="a"
.Replace What:="â", Replacement:="a"
.Replace What:="á", Replacement:="a"
.Replace What:="ç", Replacement:="c"
.Replace What:="ô", Replacement:="o"
.Replace What:="ó", Replacement:="o"
.Replace What:="ö", Replacement:="o"
.Replace What:="û", Replacement:="u"
.Replace What:="ù", Replacement:="u"
End With
End Sub |
Partager