Public Function ExtractChiffre(ByVal Cellule As Range) As String
Dim Chaine As String, Bcl As Integer
Chaine = Cellule.Value
ExtractChiffre = ""
For Bcl = 1 To Len(Chaine)
Select Case Mid(Chaine, Bcl, 1)
Case "0" To "9"
ExtractChiffre = ExtractChiffre & Mid(Chaine, Bcl, 1)
Case "A"
ExtractChiffre = ExtractChiffre & "1"
Case "B"
ExtractChiffre = ExtractChiffre & "2"
Case "C"
ExtractChiffre = ExtractChiffre & "3"
Case "D"
ExtractChiffre = ExtractChiffre & "4"
End Select
Next Bcl
ExtractChiffre = UCase(ExtractChiffre)
End Function