Public Function retrouvenombre(cellule As Range) As Double
Dim i As Byte
Dim j As Integer
For i = 1 To Len(cellule)
If IsNumeric(Mid(cellule, i, 1)) Then
For j = Len(cellule) To 1 Step -1
If IsNumeric(Mid(cellule, j, 1)) Then Exit For
Next j
Exit For
End If
Next i
retrouvenombre = Mid(cellule, i, j - i + 1)
End Function