# help with formula to insert content of 2 cells into another..

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.