Function minus(cellule) As String
minus = LCase(cellule)
minus = Trim(Replace(minus, """", ""))
minus = Replace(minus, "'", "_")
minus = Replace(minus, "_x27_", "'")
minus = Replace(minus, " ", "_")
minus = SansAccent(minus)
End Function
Function SansAccent(chaine As String)
Dim codeA$, codeB$, i%, p%
codeA = "ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÌÍÎÏìíîïÙÚÛÜùúûüÿÑñÇç"
codeB = "AAAAAAaaaaaaOOOOOOooooooEEEEeeeeIIIIiiiiUUUUuuuuyNnCc"
For i = 1 To Len(chaine)
p = InStr(codeA, Mid(chaine, i, 1))
If p Then Mid(chaine, i, 1) = Mid(codeB, p, 1)
Next
SansAccent = chaine
End Function