Option Compare Text
Function chercheExp(t$, Plage As Range)
Const u$ = "*[- '({}),.:""]", v$ = "[- '({}),.:""]*"
Dim i&, m$, c As Range, d$()
ReDim d(1 To Plage.Cells.Count, 0)
If Len(t) Then
For Each c In Plage
m = c.Text: If m Like "*" & t & "*" Then If m Like t Or m Like u & t & v Or m Like u & t Or m Like t & v Then i = i + 1: d(i, 0) = c.Address(0, 0)
Next
End If
chercheExp = d
End Function