Bonjour,
A tester:
Sub extraireValNume()
Dim i As Integer
Dim j As Integer
Dim nb As Integer
Dim Cible As String, Resultat As String
Dim Nombre As Double
For j = 1 To 5
Cible = Range("A" & j).Value
Resultat = ""
For i = 1 To Len(Cible)
If IsNumeric(Mid(Cible, i, 1)) Then
Nombre = Val(Mid(Cible, i, Len(Cible) - i + 1))
nb = nb + 1
Resultat = Resultat & Nombre & vbLf
i = i + Len(Str(Nombre)) - 1
End If
Next i
Range("B" & j).Value = Resultat
Next j
End Sub