Option Explicit
Option Compare Text
Function jour()
Dim r As Range
Dim s As Range
jour = "Jour non touvé"
Set r = Cells.Find("de:")
If Not r Is Nothing Then jour = r.End(xlToRight).Value
End Function
Sub ImportRecap()
...
dl = dl + 1
F1.Cells(dl, 1).value = jour()
...