I’m using a simple formula to combine the content of two cells into one cell, here’s an example…

in my calc file I have A1= 1001 B1= 1020

so my formula in C1 is…

=$A1&"-"$B1

result is 1001-1020

perfect. I pasted the formula into the rest of the cells in my C column.

but now I want to avoid displaying the duplicated numbers in the C cell if… the cells in the A and B column have the same number. example…

A5= 2001 B5= 2001

so my formula in C5 is…

=$A5&"-"$B5

result is 2001-2001… I would like it to display only 2001

is there a way to adjust this formula so if the 2 cell in A and B column contain the same info it does not display it twice?

any help is appreciated. thank you.