Sub Epurer()
Dim tablo, i&, s, j%, x$
With Range("X3", Range("X" & Rows.Count).End(xlUp))
tablo = .Resize(, 2) 'matrice, plus rapide, au moins 2 éléments
For i = 1 To UBound(tablo)
s = Split(tablo(i, 1))
For j = 0 To UBound(s)
x = s(j)
If Left(x, 1) <> "*" Or Right(x, 1) <> "*" Or InStr(x, "LOCAL") Then s(j) = ""
Next j
x = Application.Trim(Join(s)) 'concaténation + SUPPRESPACE
s = Split(x)
For j = UBound(s) To 1 Step -1
If s(j) = s(j - 1) Then s(j) = ""
Next j
tablo(i, 1) = Application.Trim(Join(s)) 'concaténation + SUPPRESPACE
Next i
.Value = tablo 'restitution
End With
End...