I am trying to find a function that I can use that will eliminate duplicate wording when i join two cells together. I will attach a picture to show you what my ideal return is.

CodePudding user response：

What about this one?

=IF(EQ(A2;B2);A2;TEXTJOIN(":";true;A2;B2))

nothing fancy though, if you want the fancy one, the answer with flatten from Harun24hr is better.

But it is easy in what it does, if the cells are the same, then take the first cell, otherwise, concat the results.