Function ConcatSpec(target As Range, separateur As String) As String
Dim temp As String, cell As Range
temp = ""
For Each cell In target
If cell <> "" Then temp = temp & cell.Text & Left(separateur, 1)
Next
ConcatSpec = Left(temp, Len(temp) - 1)
End Function