Function PremiersCar$(ByVal s$, Optional ByVal sep As String = ".")
Dim r$, x
For Each x In Split(Application.Proper(Application.Trim(s))): r = r & Left(x, 1) & sep: Next
PremiersCar = r
End Function
Function SansAccent(ByVal x)
Const lettresAvec = "Ÿ,À,Á,Â,Ã,Ä,Å,Ç,È,É,Ê,Ë,Ì,Í,Î,Ï,Ñ,Ò,Ó,Ô,Õ,Ö,Ù,Ú,Û,Ü,Ý,à,á,â,ã,ä,å,ç,è,é,ê,ë,ì,í,î,ï,ñ,ò,ó,ô,õ,ö,ù,ú,û,ü,ý,ÿ"
Const lettresSans = "Y,A,A,A,A,A,A,C,E,E,E,E,I,I,I,I,N,O,O,O,O,O,U,U,U,U,Y,a,a,a,a,a,a,c,e,e,e,e,i,i,i,i,n,o,o,o,o,o,u,u,u,u,y,y"
Dim i&, j&
For i = 1 To Len(x)
j = InStr(lettresAvec, Mid(x, i, 1))
If j > 0 Then x = Replace(x, Mid(x, i, 1), Mid(lettresSans, j, 1))
Next i
x = Replace(x, UCase("œ"), "OE"): x = Replace(x, "œ", "oe")
x = Replace(x, UCase("æ"), "AE"): x = Replace(x, "æ", "ae")
SansAccent = x
End Function