I need to remove a duplicate text in a cell but only if it is longer than 4 characters.
I have this formula that only works for any types of duplicate words:
=join(" ",unique(transpose(split(A1,", "))))
In this case, if a cell contains:
W3-X500 Samsung Galaxy W3-X500 5 inches and 5 different colors
It returns me:
W3-X500 Samsung Galaxy 5 inches and different colors
I will lose the second
5 character that instead I need.
How can I do it?