NEED HELP with combining two cell string values and removing duplicate String values....

I am trying to figure out how to do this and its really frustrating.

This is what i have in two different Cells

cell 1: "w1,w2,w3"
cell 2: "w2,w8,w6"


I want to combine cell 1 and cell 2 and remove duplicate string values...

This is the result i want
Cell:"w1,w2,w3,w8,w6"

can someone please help me solve this issue?

-Amrit

hello
for this particular case I have this solution

hope is helpful

katiespirations thank you for your quick response.


After looking at your sample file I see that your solution does work. However in my exact situation, the mid function has some limitations since I don't have a fixed set of numbers or a fixed number of characters in the length...

for example,

cell 1: "wx41 , w2 , w36 , r398-45"
cell 2: "w2 , x348-9d88 , w36"

This is the result I want
Cell:"w2 , w36 ,x348-9d88 ,wx41 , r398-45"

Is there a way to have it automatically find the character length and location in the string when using the MID function? or may be you would recommend a different solution?

hi again,

maybe macro is better solution,unfortunately I am not so confident about that, the only thing I have for now is sth like in the attachment
to run macro pres ctrl+b
I now is not perfect but you can see and we can work on it

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