Hi again,

Thank you for all your help. I found the solution to help me with this situation exactly the way I needed it to. I had to create a module in excel to do it.

1) hit Alt + F11 to open VB editor
2) Go to [Insert] - [Module] then paste the code
3) hit Alt + F11 again to get back to Excel


Use in cell like =CustomGT(A1, ",")


CODE BELOW

Function CustomGT(txt As String, Optional delim As String = " ") As String 
    Dim e 
    With CreateObject("Scripting.Dictionary") 
        .CompareMode = vbTextCompare 
        For Each e In Split(txt, delim) 
            If Trim(e) <> "" And Not .exists(Trim(e)) Then .add Trim(e), Nothing 
        Next 
        If .Count > 0 Then CustomGT = Join(.keys, delim) 
    End With 
End Function