Combine cells only if different value

[wonderd]

Hello everyone. Need some help with a quick formula.

I am trying to create a formula to put in C1 that will combine combine A1 and B1 only if the content is different.

Something like =A1&B1 but only combine if the contents are different.

[samba_ravi]

Try
=IF(A1<>B1,A1&B1,"")

[wonderd]

That seems to work, but I forgot to mention that if a1 and b1 are the same, then only take A1

So if A1 has the word hello and B1 has the word hello, then C1 will just report Hello

[wonderd]

Cross post, solution link below.

http://www.mrexcel.com/forum/excel-q...ml#post4347938

Sry nflsales I did not word this thread correctly.